Forum Discussion
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...
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
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
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%)