Changing the default value for an empty cell

I'm reposting my oroginal post as I made a mistake and indicated a empty cell has a value of a one when it it is actually a zero. Since the number inputted in the field will never be negative, I have entered a -1 in the entire column.

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?

Hi
still not sure but normally you could use something like
=IF(A1="","do something","do somethign else")

--
Regards
Frank Kabel
Frankfurt, Germany

"Jimbo" schrieb im Newsbeitrag
...
I'm reposting my oroginal post as I made a mistake and indicated a
empty cell has a value of a one when it it is actually a zero. Since
the number inputted in the field will never be negative, I have entered
a -1 in the entire column.

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?

Cell "A1" is for actual work and is kept empty until that date. The work can range from 0 to any number. The "IF" statement is: =If(a1=-1, (c1+b1),b1) I keep a1 at a -1 because if I keep it blank, the value of a1 is actually a 0, which is not an option.