SOLVED

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

Copper Contributor

# 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

3 Replies
best response confirmed by Peter Bartholomew (Silver Contributor)
Solution

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

In H6

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

or, if only two options exist

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

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

Thank you so much. Works great.

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

@Glennbart , you are welcome

1 best response

Accepted Solutions
best response confirmed by Peter Bartholomew (Silver Contributor)
Solution

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

In H6

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

or, if only two options exist

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