Multiple Formula In A Single Cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2672739%22%20slang%3D%22en-US%22%3EMultiple%20Formula%20In%20A%20Single%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672739%22%20slang%3D%22en-US%22%3EI'm%20facing%20a%20problem%20if%20you%20could%20find%20its%20solution.%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20cell%20A1%3CBR%20%2F%3E7650%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20cell%20B1%3CBR%20%2F%3E%3D%C3%801*20%25%20(Value%20in%20cell%20B1%20%3D%201530)%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20Cell%20C1%3CBR%20%2F%3E%3DB1*30%25%20(Value%20in%20cell%20C1%20%3D%20459)%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20cell%20D1%3CBR%20%2F%3E%3DSum(B1%2BC1)%20(Value%20in%20cell%20D1%20%3D%201989)%3CBR%20%2F%3E%3CBR%20%2F%3ENow%20the%20problem%20is%20how%20to%20put%20all%20these%20A1%2C%20B1%2C%20C1%2CD1%20in%20to%20one%20cell.%3CBR%20%2F%3EOr%3CBR%20%2F%3EAt%20least%20B1%2C%20C1%2C%20D1%20in%20one%20cell.%3CBR%20%2F%3E%3CBR%20%2F%3EUsing%20Windows%208.1%20and%20office%202010%2C%2013%20and%2016.%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2672739%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2672781%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Formula%20In%20A%20Single%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672781%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1134332%22%20target%3D%22_blank%22%3E%40atta1122%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DSUM(A1*20%25*%7B1%3B0.3%7D)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2672794%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Formula%20In%20A%20Single%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672794%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1134332%22%20target%3D%22_blank%22%3E%40atta1122%3C%2FA%3E%26nbsp%3BOr%20how%20about%20%3CSTRONG%3E%3DA1*26%25%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2672799%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Formula%20In%20A%20Single%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672799%22%20slang%3D%22en-US%22%3EThat's%20working%20but%20how%2020%20and%2030%25%20becomes%2025%25%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2672800%22%20slang%3D%22en-US%22%3ERe%3A%20Multiple%20Formula%20In%20A%20Single%20Cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2672800%22%20slang%3D%22en-US%22%3EIt%20is%20working%20too%20but%20if%20you%20could%20explain%20what%20does%20%2F%2F*%7B1%3B0.3%7D)%5C%5C%20it%20means%3F%3C%2FLINGO-BODY%3E
New Contributor
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

@atta1122 

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

@atta1122 Or how about =A1*26%

That's working but how 20 and 30% becomes 25%
It is working too but if you could explain what does //*{1;0.3})\\ it means?

@atta1122 

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

 

@atta1122 

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

 

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

@atta1122 Perhaps this picture will make it clear. It's very basic maths.

Screenshot 2021-08-22 at 11.40.43.png

 

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