Oct 26 2022 03:01 AM
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
Oct 26 2022 03:15 AM - edited Oct 26 2022 03:42 AM
Oct 26 2022 06:19 AM
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
Oct 26 2022 06:41 AM
Oct 26 2022 07:36 AM
@Robert_Burrows Just like I wrote in my initial response. No need for the intermediate calculations.
Oct 27 2022 01:20 AM