It worked. Thank you On Sat, Mar 7, 2009 at 4:25 PM, Gene Young <[email protected]> wrote:
> 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: [email protected] > For additional commands, e-mail: [email protected] > >
