Forum Discussion

Copper Contributor

Aug 22, 2021

Multiple Formula In A Single Cell

I'm facing a problem if you could find its solution. In cell A1 7650 In cell B1 =À1*20% (Value in cell B1 = 1530) In Cell C1 =B1*30% (Value in cell C1 = 459) In cell D1 =Sum(B1+C1) (Va...

excel

Formulas and Functions

training

atta1122

Copper Contributor

Aug 22, 2021

That's working but how 20 and 30% becomes 25%

Riny_van_Eekelen

Platinum Contributor

Aug 22, 2021

atta1122

Well, 20% plus 30% of 20% equals 26%.

atta1122
Copper Contributor
Aug 22, 2021
Ok that's good
but I am not math guy that's beyond my approach
is there any other easiest way to calculate all the stuff?
And thank you for earlier response
- SergeiBaklan
  Diamond Contributor
  Aug 22, 2021
  atta1122
  
  You may practically literally translate your text into formulas
  
  ---
  
  In cell B1
  =À1*20% (Value in cell B1 = 1530)
  In Cell C1
  =B1*30% (Value in cell C1 = 459)
  
  or
  
  =(A1*20%)*30%
  
  In cell D1
  =Sum(B1+C1) (Value in cell D1 = 1989)
  
  or
  
  =A1*20% + (A1*20%)*30%
  
  or
  
  =A1*20%*(1+30%)
- Riny_van_Eekelen
  Platinum Contributor
  Aug 22, 2021
  atta1122 Perhaps this picture will make it clear. It's very basic maths.