Formula in Excel with a particular increment value

0 votes
I need to use Excel formulas for something. I'm attempting to make a simple Excel file with a few columns. Number of VMs is listed in one of the columns. "Avg. Monthly Backup Data (GB)" is listed in another column.

I want the outcome listed below.

The average monthly backup data (GB) for a single virtual machine will be 429 GB. Average Monthly Backup Data (GB) will increase by 430 GB if the number of VMs is increased by 1.

So, if there are two virtual machines, the average monthly backup data (GB) will be 429+430 = 859 GB, and so on.

How can I write this formula such that it increases the average monthly backup data by 430 GB depending on the number of virtual machines?
Apr 10, 2023 in Others by Kithuzzz
 • 38,010 points • 198 views

No answer to this question. Be the first to respond.

Your answer

Your name to display (optional):
Privacy: Your email address will only be used for sending these notifications.

Related Questions In Others

0 votes
1 answer

Is there a way to use LOOKUP/VLOOKUP/HLOOKUP to return headers in EXCEL. Current formula returning wrong value

Try this: =SUMPRODUCT(--(Schedule!$B$3:$F$7=A3)) READ MORE

answered Nov 6, 2022 in Others by narikkadan
 • 63,420 points • 581 views
0 votes
1 answer

MS Excel showing the formula in a cell instead of the resulting value

Make sure that... There's an = sign before the formula There's ...READ MORE

answered Nov 8, 2022 in Others by narikkadan
 • 63,420 points • 550 views
0 votes
1 answer

Text with a dash in the cell but not in the formula bar (Excel)

What you have got here is called ...READ MORE

answered Nov 13, 2022 in Others by narikkadan
 • 63,420 points • 1,761 views
0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

answered Feb 6, 2023 in Others by narikkadan
 • 63,420 points • 590 views
0 votes
1 answer

How to search a file with a particular extension and a particulat string in its name?

You can easily find the file using ...READ MORE

answered Mar 8, 2019 in Others by Nabarupa
 • 597 views
0 votes
1 answer

How to create a drop-down in excel with custom values

You can accomplish that using code rather ...READ MORE

answered Sep 25, 2022 in Others by narikkadan
 • 63,420 points • 742 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18, 2022 in Others by Edureka
 • 13,670 points • 265 views
0 votes
1 answer

In excel how do I reference the current row but a specific column?

Put a $ symbol in front of ...READ MORE

answered Oct 15, 2022 in Others by narikkadan
 • 63,420 points • 1,358 views
0 votes
1 answer

Excel function for divide or split number to maximum possible equal parts

The underlying math for this is as ...READ MORE

answered Oct 17, 2022 in Others by narikkadan
 • 63,420 points • 1,996 views
0 votes
0 answers

How to create DropDown which have dynamic Validation List

In my data table, the columns "Category" ...READ MORE

Oct 31, 2022 in Others by Kithuzzz
 • 38,010 points • 436 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP
"PMP®","PMI®", "PMI-ACP®" and "PMBOK®" are registered marks of the Project Management Institute, Inc. MongoDB®, Mongo and the leaf logo are the registered trademarks of MongoDB, Inc.