Adding a percentage to a sum with a changing value

0

I am having trouble creating a formula that when it's multiplied by four different cell, one of the cells changes numbers and I want the total to go up by .02% each time the number goes up. Example... the number 1 has no affect to the total but the number 2 adds .02% to the total, the number 3 adds .04% to the total and so on until you reach the number 6. I know I'm not in you class but I havent found any of you videos that have this. Please!! I need your help!! Thank you in advance!! Bert

Answer
Discuss

Answers

0
Selected Answer

In the attached workbook this formula is doing the job you describe. Note that entering zero also doesn't change the original number, same as 1.

=B2+IF(B4,(B4-1)*B3,0)

Here B2 holds the fixed number (23 in my example), B4 the multiplicator and B3 the factor of change (0.02 as per your example). The two given components (23 and 0.02) could be incorporated into the formula. It would then look like this.

=23+IF($B$4,($B$4-1)*0.02,0)
Discuss

Discussion

Is there a way I can download the spreadsheet for you to look at?
BertFelipe (rep: 2) Sep 19, '19 at 6:28 pm
Edit your original question. Scroll down to the bottom and click on “Add files”. Browse to select the workbook to attach.
Variatus (rep: 4864) Sep 19, '19 at 8:40 pm
Add to Discussion


Answer the Question

You must create an account to use the forum. Create an Account or Login