Blank Cell vs Cell equal to Zero (0)

[LavaDude]

When creating a formula, is there a way to differentiate between a blank
cell and a cell that's equal to 0?

Here's my formula:

=IF('2005 Sales'!O12>0,'2005 Sales'!O12,"")

I wanted to change this to if O12 is greater than or equal to 0, then
return O12, but I want it to return ("") if the contents of O12 is blank.
Is there a way to do this? ...

TIA!

LavaDude

 

[RagDyer]

What happens if O12 is *less* then zero?

This will leave O12 blank ( "" ) if less then zero:

=IF(AND(ISNUMBER(O12),O12>=0),O12,"")

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

 

[Dnereb]

Test for the length of the content

=IF(Len('2005 Sales'!O12)>0,'2005 Sales'!O12,""

 

[LavaDude]

What happens if O12 is *less* then zero?

This will leave O12 blank ( "" ) if less then zero:

=IF(AND(ISNUMBER(O12),O12>=0),O12,"")

Thanks! I'll give this a try ...

BTW, there's a formula in O12 that will not allow it to be less than zero.

Aloha!

LavaDude

 

[LavaDude]

Test for the length of the content

=IF(Len('2005 Sales'!O12)>0,'2005 Sales'!O12,"")

Thanks! This works great too! ... I eventually found "ISBLANK" to solve my
problem:

=IF(ISBLANK('2005 Sales'!O12),"",'2005 Sales'!O12)

Aloha!

LavaDude