Forum Discussion
Glennbart
Nov 17, 2023Copper 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
In H6
=IF(G6="Bill", F6, IF(G6="Pending", G6, "something else") )
or, if only two options exist
=IF(G6="Bill", F6, G6 )