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...
=SUM(A1*20%*{1;0.3})
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})