# 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

0

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)``