#DIV/O Error Formatting (Excel 2003)

Topic

New Reply

Could someone provide me the proper custom format for hiding/changin the #DIV/O error. Hiding might just be “-” or ” “.

Thank you

Reply | Quote

Replies

There are two easy options:
1. Rewrite your formula to include an error check.
2. Use conditional formatting with an expression like =iserror(A1) and set the font colour to white.
HTH

Reply | Quote

If your formula is something like =A1/B1, then you can change it to something like:


=IF(ISERROR(A1/B1),"",A1/B1)


Reply | Quote

ISERR will trap any error value except #N/A
ISERROR will trap them all (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, and #NULL!)

Reply | Quote