SOLVED

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

Copper Contributor

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

@Glennbart 

In H6

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

or, if only two options exist

=IF(G6="Bill", F6, G6 )
Thank you so much. Works great.
1 best response

Accepted Solutions
best response confirmed by Peter Bartholomew (Silver Contributor)
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 )

View solution in original post