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,
If(B1="","","True")

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

"Jim" wrote:

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

Look in the help index for IF

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jim" wrote in message
...
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,,"")

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Jim" wrote:

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