How do I account for empty cells?

[codedreamer]

I have several conditionals in a cell is something like this: =IF(AND(A1<2,B2>4),"1")
How do I get the result to be an empty cell if either A1 or A2 are blank(no data in them)?
I tried isblank, but did not worked for me, I also tried saying A1="", but it did not work either, neither <> worked. Any help is appreciated.

Thanks.

 

[Asheesh]

hi,
Check if the below works..

IF(OR(A1="",A2=""),"",IF(AND(A1<2,B2>4),"1"))

If it is not working can you share your file please.

 

[pecoflyer]

Be aware that 1 between double quotes is a text string...

 

[Peter Bartholomew]

The condition gets a bit simpler if you can treat both zero and blanks as invalid. The shortest formula is one that would give TRUE for conditions that match your criteria and FALSE for those that do not.
= IF( A1*B2, AND(A1<2,B2>4), "" )

If you really want the text character "1" for true and FALSE when the condition is not satisfied you would need to put the logical expression within an IF function
= IF( A1*B2, IF(AND(A1<2,B2>4),"1",FALSE), "" )
but it is an odd requirement.