Default Value for an empty cell

I am trying to use an "IF" statement which it checks the value of a cell. If there isn't any input, including a zero, I want it to do one thing and another thing if any number, including a zero is entered. Unfortunately an empty cell has a value of one. Can that be changed?

Thanks.

Hi
please post your current formula (an empty cell is not treated as '1')

--
Regards
Frank Kabel
Frankfurt, Germany


Jimbo wrote:
I am trying to use an "IF" statement which it checks the value of a
cell. If there isn't any input, including a zero, I want it to do one
thing and another thing if any number, including a zero is entered.
Unfortunately an empty cell has a value of one. Can that be changed?

Thanks.

Maybe try.........

=IF(OR(F1=0,LEN(F1)=0),"NoNumber","number")

or

=IF(F10,"Number","NoNumber")


Vaya con Dios,
Chuck, CABGx3



"Jimbo" wrote in message
...
I am trying to use an "IF" statement which it checks the value of a cell.
If there isn't any input, including a zero, I want it to do one thing and
another thing if any number, including a zero is entered. Unfortunately an
empty cell has a value of one. Can that be changed?

Thanks.