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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare Two Cells 1
if then formula 2
need formula returning a blank cell 4
Need Formula - If blank cells 3
Looking at multiple cells 3
How to set the formula? 4
if then formula 1
if formula? 2

Top