ExcelBanter - My formula have error, so I remove errors.

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - My formula have error, so I remove errors. (https://www.excelbanter.com/excel-discussion-misc-queries/171462-my-formula-have-error-so-i-remove-errors.html)

Feejo

My formula have error, so I remove errors.

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

Jon Peltier

My formula have error, so I remove errors.

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.

Feejo

My formula have error, so I remove errors.

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.

All times are GMT +1. The time now is 03:33 PM.