Forum Discussion
cell A2 = 100 of which 4% = 40 then add 20% = 8 giving a total of 48
I need a formula to determine two calculations as in cell A2 = 100. Calculate 4% of that which is 40, then calculate 20% of that which is 8 and add the two numbers to give me a total of 48
Sorry I mistyped my original question showing 4% not 40%
I need to find a 40 percent factor of the original number and then add 20% to that total.
So if I start with A2 has 100 in it. I then want to find 40% of that number I write in B2 =Sum(A2/100*40) which gives me 40. I then need to add 20% to the number 40 in B2 so in C2 I write =Sum(B2/100*20) which gives me the number in C2 as 8. Finally I need to show the combined total of the two calculations so in D2 I write =Sum(B2:C2) which gives me 48
Could you please express to my significant misunderstanding how I should write the required formula in one line
Robert_Burrows Just like I wrote in my initial response. No need for the intermediate calculations.
- 100% agree your method is the most accurate and efficient. For us less accomplished users it is sometimes hard to understand the reasons behind the formulas. I was trying to show a way of explaining the formula and not just the math 😁
