How can you format a cell to be blank after.....

Posted by Ty Agboola on July 10, 2001 11:31 AM

Does anyone know how to stop a cell from displaying 0 when I set it equal to the value of another cell (using the formula: =sheet1!a1)?

Posted by Gregc on July 10, 2001 11:41 AM

=if(sheet1!a1 = 0,"",sheet1!a1)