 # 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) (Value in cell D1 = 1989)

Now the problem is how to put all these A1, B1, C1,D1 in to one cell.
Or
At least B1, C1, D1 in one cell.

Using Windows 8.1 and office 2010, 13 and 16.
9 Replies

# Re: Multiple Formula In A Single Cell

``=SUM(A1*20%*{1;0.3})``

# Re: Multiple Formula In A Single Cell

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

# Re: Multiple Formula In A Single Cell

It is working too but if you could explain what does //*{1;0.3})\\ it means?

# Re: Multiple Formula In A Single Cell

That's an array constant with the values of 100% and 30%.

A variation of the formula explains why @Riny_van_Eekelen uses 26%. The result of the sum is 26%.

``=A1*SUM(20%*{1;0.3})``

# Re: Multiple Formula In A Single Cell

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

# Re: Multiple Formula In A Single Cell

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

# Re: Multiple Formula In A Single Cell

@atta1122 Perhaps this picture will make it clear. It's very basic maths. # Re: Multiple Formula In A Single Cell

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%)