Forum Discussion

FamePrincess17's avatar
FamePrincess17
Copper Contributor
Jun 16, 2022
Solved

Multiple IF functions in one cell

I cannot figure out how to create multiple IF functions in one cell. I need for one cell to show A2, A3, or A4 based off if the cell before has 907.643-13(A2), 907.645-13(A3), or 907.647-13(A4). How ...
excel
Formulas and Functions
  • OliverScheurich's avatar
    OliverScheurich
    Jun 16, 2022

    FamePrincess17 

    =IF(A6="907.643-13",A2,IF(A6="907.645-13",A3,IF(A6="907.647-13",A4,"")))

    Maybe with this formula.

     

OliverScheurich's avatar
OliverScheurich
Gold Contributor
Jun 16, 2022

FamePrincess17 

=IF(A6="907.643-13",A2,IF(A6="907.645-13",A3,IF(A6="907.647-13",A4,"")))

Maybe with this formula.

 

  • FamePrincess17's avatar
    FamePrincess17
    Copper Contributor
    Jun 16, 2022
    OH MY GOODNESS THAT WORKED!!! I did something similar to this earlier but I must've missed something.
    #GENIUS lol

Resources