IF Then

J

Jim

Hello,

and thanks for hte help.

What formula do I use if in A1 I want to return TRUE, if B1 has a 1, and,
return a balnk cell if B1 is blank?

Thanks
Jim
 
E

Eduardo

Hi,
If(B1="","","True")

I assumed blank if b1 is blank and true if it's other value
 
S

Shane Devenshire

Hi,

Your question is incomplete - what if B1 is something other that 1 or blank?

If those are the only two choices, then try

=IF(B1=1,,"")
 
Top