Both of the suggestions works. Thank you. On Sun, Mar 8, 2009 at 2:37 PM, Brian Barker <b.m.bar...@btinternet.com>wrote:
> At 14:24 08/03/2009 -0600, Walter Hildebrandt wrote: > >> The spreadsheet is both large and complicated. >> > > I don't think that's relevant! > > I have a new questions >> If A1 is empty then B1 should be empty >> If A1 has a 0 then B1 should have 0 (a zero) >> If A1 has any number except 0, then that number should be in B1 >> > > This can be solved by the *other* suggestion provided earlier: > =IF(ISBLANK(A1);"";A1) > > An alternative could be: > =IF(ISNUMBER(A1);A1;"") > > I trust this helps. > > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: users-unsubscr...@openoffice.org > For additional commands, e-mail: users-h...@openoffice.org > >
