Forum Discussion

Glennbart's avatar
Glennbart
Copper Contributor
Nov 17, 2023
Solved

Help, I forgot how to write a "if" statement formula

Hello and thank you in advance.   I used to know how to do this but my brain is mush lately.   So, I am trying to create a :If" formula that looks at a cell with 2 choices in a drop down menu Bil...
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 17, 2023

    Glennbart 

    In H6

    =IF(G6="Bill", F6, IF(G6="Pending", G6, "something else") )

    or, if only two options exist

    =IF(G6="Bill", F6, G6 )
SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Nov 17, 2023

Glennbart 

In H6

=IF(G6="Bill", F6, IF(G6="Pending", G6, "something else") )

or, if only two options exist

=IF(G6="Bill", F6, G6 )
Glennbart's avatar
Glennbart
Copper Contributor
Nov 17, 2023
Thank you so much. Works great.

Resources