Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

#div/0!

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?

Check out our Excel Resources

Re: #div/0!

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.

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

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

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.