MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Formula Display

Posted by Marc on January 22, 2002 10:12 AM

How to I format cells so that when there is a formula but no underlying data the cells are left blank rather than '-' or '#N/A' for example?

Posted by on January 22, 2002 10:23 AM

=if(data cell = "","",calculation) (NT)