I just need to wait 5 minutes.

"Jon Peltier" wrote:

I remove error from option

I don't know what you mean. Adjust your formula:

=IF(B1<0,A1/B1,"")
=IF(B1<0,A1/B1,0)

Put something sensible in the last position in the IF() statement.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Feejo" wrote in message
...
I remove error from option, and error show again Div/0. When I try to click
Error checking Excel is not responding.