MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Paul on November 20, 2001 6:35 AM

I set up a template with a division formula that returns this error (error is eliminated when data is entered.) Is there a formula I can use to return a blank instead of this error until I enter data?

Posted by Daniel P. on November 20, 2001 6:45 AM

Try "=IF(ISBLANK(B1),"",A1/B1)", using B1 as the cell to have data entered into.

Daniel P.

Posted by anno on November 20, 2001 4:49 PM

=IF(B1,A1/B1,"") is simplest way? (nt)