I am using the following formula:
=O260/(COUNTIF('CLOSED SALES ORDERS'!$A$2:$A$14765,'Input Sheet'!G260))
This works just fine if the value column O260 is on the Closed Sales Order Tab. If it does not exist, I get the following error:
#DIV/0!
Is there any way to replace the #DIV/0! with a zero or a blank?
I tried using ISERROR but it didn't seem to work. Maybe I'm not using it properly.
Can anyone help me?
Bookmarks