IF Then

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
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,,"")
 
Back
Top