Help with IF Function

  • Thread starter Thread starter Jim
  • Start date Start date
J

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?
 
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?
Click to expand...

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


--ron
 
Back
Top