Replace #/Div
Thank you!!!!!
"Jacob Skaria" wrote:
=IF(ISERROR(<your formula),"N/A",<your formula)
If this post helps click Yes
---------------
Jacob Skaria
"Alfred90210" wrote:
Isn't there an 'Excel Option' that allows you to enter value (Free Text... IE
N/A) when you get a #/div error?
I know that pivot tables have that option, but I'm not using a pivot table
and I'd like to use that option. Thanks in advance!!
|