Im working on updating some forms and Im having trouble with one of the cells.

=IF(AT238-AT196=0,"", AT238-AT196)
If this cell has a value of 0 then print nothing, else, print the value.

= IF(AU238>1, 1)
+ IF(AV238>1, 1)
+ IF(AW238>1, 1)
+ IF(AX238>1, 1)
+ IF(AY238>1, 1)

And then I have a column (actually multiples of columns) that talleys the results.

The problem is Im getting 5 every time even though some cells are empty.
Does "" not mean the same as nothing or null?

Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]

Reply via email to