IF Then

[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

 

[Eduardo]

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

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

 

[Don Guillett]

Look in the help index for IF

 

[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,,"")