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 Bill or Pending (G6)

 

if the (G6) answer is Bill, then it takes the value in F6 and copies it to H6.

if the (G6) answer is Pending, then it  writes Pending  in H6

 

 

Thank you again,

GB

  • Glennbart 

    In H6

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

    or, if only two options exist

    =IF(G6="Bill", F6, G6 )

Resources