New Contributor

# 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.
19 Replies

# Re: Multiple Formula In A Single Cell

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

# Re: Multiple Formula In A Single Cell

@atta1122 Or how about =A1*26%

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

# Re: Multiple Formula In A Single Cell

Hi!

Please advise how to combine the below formula in single cell

=MATCH(V15,B2:B501,0) & =MATCH(V15,C2:C501,0)

# Re: Multiple Formula In A Single Cell

Please explain what the end result should be.

# Re: Multiple Formula In A Single Cell

I want to find the row number or column number of selected value from a table

# Re: Multiple Formula In A Single Cell

The first formula it will show the row number of the value selected from column B
The 2nd formula it will show the row number of the value selected from column C
I want to combine these two formulae or more in a single cell to show the value selected either from column B or C or etc.

# Re: Multiple Formula In A Single Cell

Perhaps

=IFERROR(MATCH(V15,B2:B501,0),MATCH(V15,C2:C501,0))

# Re: Multiple Formula In A Single Cell

Hi Hans,
Thank you for your quick response, it is working but when I am adding formula like the one below because I am having 21 columns, it is giving me message box saying, "you entered too few arguments for this function".
MATCH(V15,D2:D501,0)

# Re: Multiple Formula In A Single Cell

Let's say you want to look at C2:U501. Use the following formula. If you don't have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.

=IFERROR(MATCH(V15,INDEX(C2:U501,0,MIN(IF(C2:U501=V15,COLUMN(C2:U2)-COLUMN(C2)+1))),0),"")

# Re: Multiple Formula In A Single Cell

Hi Hans,
That was amazing it is working alright, thank you very much!
Please can you do the formula vice versa now I need to find the column.

# Re: Multiple Formula In A Single Cell

Sure. Again, if you don't have Microsoft 365 or Office 2021, confirm by pressing Ctrl+Shift+Enter:

=IFERROR(MATCH(V15,INDEX(C2:U501,MIN(IF(C2:U501=V15,ROW(C2:C501)-ROW(C2)+1)),0),0),"")

# Re: Multiple Formula In A Single Cell

Hi Hans,
Thank you very much, it is working.
That was amazing.