=A1 does not work because B1 will not be empty when A1 has a 0 in it. On Sun, Mar 8, 2009 at 10:01 AM, Michael Adams <[email protected]>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. > > In B1 type > > =a1 > > > > -- > Michael > > All shall be well, and all shall be well, and all manner of things shall > be well > > - Julian of Norwich 1342 - 1416 > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
