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) (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.
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.
19 Replies
atta1122 Or how about =A1*26%
- That's working but how 20 and 30% becomes 25%
=SUM(A1*20%*{1;0.3})Hi!
Please advise how to combine the below formula in single cell
=MATCH(V15,B2:B501,0) & =MATCH(V15,C2:C501,0)
Please explain what the end result should be.
- It is working too but if you could explain what does //*{1;0.3})\\ it means?
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})
