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
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Adding a percentage to a sum with a changing value
0
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)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: 4889) Sep 19, '19 at 8:40 pm