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: [email protected]
For additional commands, e-mail: [email protected]
