Help with IF Function

[Jim]

I am having actual data inputted in the "C" column and I
compare the "C" column with the "B" column which is the
proposed quantity. In the "D" field I do a status update
only if there is data(number) in the "C". If there isn't
any data, I want the field to display a word and if there
is a number (including zero) I do a calculation. However,
an IF statement treats a blank cell as a zero which is a
number. Is there a way to default a blank field to a -1 or
can I do this another way?

 

[Ron Rosenfeld]

I am having actual data inputted in the "C" column and I
compare the "C" column with the "B" column which is the
proposed quantity. In the "D" field I do a status update
only if there is data(number) in the "C". If there isn't
any data, I want the field to display a word and if there
is a number (including zero) I do a calculation. However,
an IF statement treats a blank cell as a zero which is a
number. Is there a way to default a blank field to a -1 or
can I do this another way?

=IF(ISBLANK(C1),"word","calculation")


--ron

 

[Max]

Try something like: =IF(ISBLANK(C1),"No input",C1+B1)
or : =IF(C1="","No input",C1+B1)