At 14:54 07/03/2009 -0700, Walter Hildebrandt wrote:
I am using 3.1 with WindowsXP
I cannot speak for 3.1: I'm using the (stable) 3.0.1.
In Calc, Cell A1 is either empty or has a 0 in it.
Cell B1 has [] =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?
Try:
=IF(A1=0;"";A1+20)
or:
=IF(A1=0;"Zero";A1+20)
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
