The spreadsheet is both large and complicated. 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
On Sun, Mar 8, 2009 at 1:31 PM, Brian Barker <[email protected]>wrote: > At 18:41 08/03/2009 +0000, Harold Fuchs wrote: > >> On Sun, 08 Mar 2009 09:51:22 -0600 >> Came this utterance formulated by Walter Hildebrandt to my mailbox: >> >>> Sorry for the confusion. i will try again. >>> If A1 is empty or has an 0 in it, I want B1 to be empty. At the same >>> time if A1 has any number in it, I want B1 to have that number in B1. >>> >> >> Format column B to have no leading zeros: >> * Right click in the column heading >> * Select Format Cells >> * In the middle of the panel that opens is a box labelled "Leading zeros"; >> change the value to 0. >> Done. >> > > This is an interesting alternative technique. It is worth mentioning that > there is an important difference here (of which I imagine you are aware). > With the earlier solutions, the B cell is genuinely empty, whereas in your > scheme it has a zero value which is arranged to display as if empty. This > could have ramifications, of course, in any other cells which make use of > such values. If we put =B1 into C1, for example, the earlier techniques > produce another empty cell, whereas yours produces an explicit zero (which > obviously could be suppressed in the same way). Either could be preferable. > > (For the avoidance of doubt, this is an observation, not a criticism!) > > Brian Barker > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
