| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get rid of DIV/0 error message
Is there a command to return a value of 0 instead of DIV/0 error message?
Thanks!! -- Jeff |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of DIV/0 error message
Something like this:
=IF(B1=0,0,A1/B1) or more generally: =IF(ISERROR(your_formula),0,your_formula) though this would mask all errors. Hope this helps. Pete On Dec 11, 4:38*pm, Jeff wrote: Is there a command to return a value of 0 instead of DIV/0 error message? Thanks!! -- Jeff |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of DIV/0 error message
=IF(Iserror(YourCellreference),0,(YourCellreferenc e))
-- If this posting was helpful, please click on the Yes button. Regards, Michael Arch. "Jeff" wrote: Is there a command to return a value of 0 instead of DIV/0 error message? Thanks!! -- Jeff |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of DIV/0 error message
Thank you!
-- Jeff "Pete_UK" wrote: Something like this: =IF(B1=0,0,A1/B1) or more generally: =IF(ISERROR(your_formula),0,your_formula) though this would mask all errors. Hope this helps. Pete On Dec 11, 4:38 pm, Jeff wrote: Is there a command to return a value of 0 instead of DIV/0 error message? Thanks!! -- Jeff |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Get rid of DIV/0 error message
You're welcome.
Pete On Dec 11, 5:04*pm, Jeff wrote: Thank you! -- Jeff |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error message | Setting up and Configuration of Excel | |||
| Error message box | Excel Discussion (Misc queries) | |||
| VBA Error Message "Compile Error...." | Excel Discussion (Misc queries) | |||
| changing the message in an error message | Excel Worksheet Functions | |||
| How do I get rid of "Compile error in hidden module" error message | Excel Discussion (Misc queries) | |||
Linear Mode
