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

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!
==============================================


"LavaDude" <(E-Mail Removed)> wrote in message
news:Xns96CC7047AE4Amikioigtenet@216.168.3.44...
>
> 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

Test for the length of the content

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

--
Dnere

-----------------------------------------------------------------------
Dnereb's Profile: http://www.excelforum.com/member.php...fo&userid=2618
View this thread: http://www.excelforum.com/showthread.php?threadid=46639

"RagDyer" <(E-Mail Removed)> wrote in news:O2wqdmYtFHA.904
@tk2msftngp13.phx.gbl:

> 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

Dnereb <(E-Mail Removed)> wrote in
news(E-Mail Removed):

>
> 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