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
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 😁