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

[Glennbart]

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

[#2 · Accepted solution]

@Glennbart 

In H6

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

or, if only two options exist

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

[#3]

Thank you so much. Works great.

[#4]

@Glennbart , you are welcome