Walter Hildebrandt wrote:
I am using 3.1 with WindowsXP
In Calc, Cell A1 is either empty or has a 0 in it.
Cell B1 has either =A1+20 in it.
When cell A1 is either empty or has a 0 in it, I want cell B1 to be empty or
in some way indicate that A1 is either empty or has a 0 in it.
If any number, except 0, is in cell A1 I want B1 to have the correct answer.
What is the correct entry to make in B1?
=IF(A1;A1+20;"")
--
Gene Y.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@openoffice.org
For additional commands, e-mail: users-h...@openoffice.org