| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
#DIV/0 Error
I have the following formula for numbers containing zero and need a revised
formula to show 0% instead of the #DIV/0 Orig formula i s: =(C54/4)/D54 Helppppp! I'm in a time crunch -- Dianne |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0 Error
=IF(ISERROR(yourformula),0,yourformula)
and format as % -- Gary''s Student - gsnu200839 "Dianne HMM" wrote: I have the following formula for numbers containing zero and need a revised formula to show 0% instead of the #DIV/0 Orig formula i s: =(C54/4)/D54 Helppppp! I'm in a time crunch -- Dianne |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0 Error
Try this:
=IF(D54=0,0,(C54/4)/D54) -- Biff Microsoft Excel MVP "Dianne HMM" wrote in message ... I have the following formula for numbers containing zero and need a revised formula to show 0% instead of the #DIV/0 Orig formula i s: =(C54/4)/D54 Helppppp! I'm in a time crunch -- Dianne |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0 Error
=IF(OR(D5="",D5=0),0,(C5/4)/D5)
Gord Dibben MS Excel MVP On Tue, 17 Mar 2009 10:42:05 -0700, Dianne HMM wrote: I have the following formula for numbers containing zero and need a revised formula to show 0% instead of the #DIV/0 Orig formula i s: =(C54/4)/D54 Helppppp! I'm in a time crunch |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
#DIV/0 Error
Hi,
Try =IF(D54=0,0,C54/(4*D54)) -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Dianne HMM" wrote: I have the following formula for numbers containing zero and need a revised formula to show 0% instead of the #DIV/0 Orig formula i s: =(C54/4)/D54 Helppppp! I'm in a time crunch -- Dianne |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Visual Basic Error Run Time Error, Type Mismatch | Excel Discussion (Misc queries) | |||
| Error of slope taking into account error of the data points | Excel Worksheet Functions | |||
| Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
| I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Linear Mode
