Walter, That would be =IF(A1="";"";A1).
Walter Hildebrandt wrote:
What formula can be used to do all of the following; 1) If A1 is a positive number that number will appear in B1 2) If A1 is 0 (a zero) that number will appear in B1 3) If A1 has a negative number that negative number will appear in B1 4) If A1 is empty then B1 will be empty
-- Andy Brown La Mesa, CA 91942 www.the-martin-byrd.net/openoffice.org.html OpenOffice.org Community Distributor CD/OEM Distribution Project member Documentation Project member Marketing Project member --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
