Forum Discussion

Copper Contributor

Aug 22, 2021

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...

excel

Formulas and Functions

training

Detlef_Lewin

Silver Contributor

Aug 22, 2021

atta1122

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

AA-ACTS

Copper Contributor

Oct 10, 2022

Detlef_Lewin

Hi!

Please advise how to combine the below formula in single cell

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

HansVogelaar
MVP
Oct 10, 2022
AA-ACTS

Please explain what the end result should be.
- AA-ACTS
  Copper Contributor
  Oct 10, 2022
  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.
  - HansVogelaar
    MVP
    Oct 10, 2022
    AA-ACTS
    
    Perhaps
    
    =IFERROR(MATCH(V15,B2:B501,0),MATCH(V15,C2:C501,0))
- AA-ACTS
  Copper Contributor
  Oct 10, 2022
  I want to find the row number or column number of selected value from a table