Multiple Formula In A Single Cell

[atta1122]

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.

[#2]

@atta1122 

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

[#3]

@atta1122 Or how about =A1*26%

[#4]

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

[#5]

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

[#6]

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

[#7]

@atta1122 

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

[#8]

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

[#9]

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

[#10]

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

[#11]

@Detlef Lewin 

Hi!

Please advise how to combine the below formula in single cell

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

[#12]

@AA-ACTS 

Please explain what the end result should be.

[#13]

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

[#14]

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.

[#15]

@AA-ACTS 

Perhaps

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

[#16]

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)

[#17]

@AA-ACTS 

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),"")

[#18]

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.

[#19]

@AA-ACTS 

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),"")

[#20]

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