| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you write an if statement that replaces #DIV/0! with 0 | Excel Discussion (Misc queries) | |||
| How to replace div/0 with a zero | Excel Discussion (Misc queries) | |||
| #DIV/0! query | Excel Discussion (Misc queries) | |||
| How to hide #DIV/0! in cells waiting for input? | Excel Discussion (Misc queries) | |||
| # DIV/0! error in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
