Conditions

  • Thread starter Thread starter Jim
  • Start date Start date
J

Jim

Hello,

Thanks in advance for the help.

I want to return the word "TRUE" in column G2 if column A2 shows "SF" and
Column I2 is blank.

If column A shows anything other than "SF" it will not meat the condition
and G2 should remain blank. If I2 shows any data, then G2 should remian
blank.

Again, thanks for the help.

Jim
 
Use this formula.

=IF(AND((A2="SF"),(I2="")),"TRUE","")

If this post helps, Click Yes!
 
Yes, but you don't need so many parentheses.
You can change
=IF(AND((A2="SF"),(I2="")),"TRUE","")
to
=IF(AND(A2="SF",I2=""),"TRUE","")

And are you sure that the OP wanted the text string "TRUE"? If Jim wanted
the boolean value TRUE, throw away the quote marks round it, and make it
=IF(AND(A2="SF",I2=""),TRUE,"")
 
Back
Top