My formula have error, so I remove errors.

F

Feejo

I remove error from option, and error show again Div/0. When I try to click
Error checking Excel is not responding.
 
J

Jon Peltier

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
 
F

Feejo

I just need to wait 5 minutes.

Jon Peltier said:
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
_______
Click to expand...
 
Top