This might do it ...
=IF(AND(ISNUMBER(D91),D91<0),D71/D91,"More zero data!")
Rgds,
ScottO

wrote in message
oups.com...
| Ok, I'm nuts. I retrieve data constantly into an existing
workbook.
| Where the data is zero, when imported, it comes in as text, thus
| causing #div/0! errors. Of course, I've included an IF function
that
| should return N/A or heck - I'd take a 'zero' at this point.
Nadda.
| Below is the formula I'm using and I'd appreciate an adjustment to
get
| this one right! =IF(D91=0,0,D71/D91). Function won't accept
=IF(D91="
| ",0,D71/D91). Suggestion? Thx.
|