ExcelBanter - DIV/0!

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - DIV/0! (https://www.excelbanter.com/excel-worksheet-functions/81436-div-0-a.html)

Benjamin

DIV/0!

I would like to build an =IF formula that would put something other than
DIV/0! in a cell, but I am not sure what the logical test should be.

I tried: =IF(ISERROR(...

and =IF(0,(..

and =IF(""(...

Any help?

TIA

Niek Otten

DIV/0!

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

--
Kind regards,

Niek Otten

"Benjamin" wrote in message ...
I would like to build an =IF formula that would put something other than
DIV/0! in a cell, but I am not sure what the logical test should be.

I tried: =IF(ISERROR(...

and =IF(0,(..

and =IF(""(...

Any help?

TIA

Benjamin

DIV/0!

Thank you.

"Niek Otten" wrote:

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

--
Kind regards,

Niek Otten

"Benjamin" wrote in message ...
I would like to build an =IF formula that would put something other than
DIV/0! in a cell, but I am not sure what the logical test should be.

I tried: =IF(ISERROR(...

and =IF(0,(..

and =IF(""(...

Any help?

TIA

All times are GMT +1. The time now is 01:12 AM.