| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Dont want #DIV/0!.
This is my formula =IF(Q8="0",0%,P8/Q8). Cell P8 and Q8 are formatted as
time (37:30:55) If cells P8 and Q8 equal 0:00:00 then my answer is #DIV/0!. I want the answer to be 0.0% . How do I do that? Thanks |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dont want #DIV/0!.
=IF(iserror(Q8="0",0%,P8/Q8),"0",(Q8="0",0%,P8/Q8))
try that :) susan On Jan 3, 9:57*am, Wanna Learn wrote: This is my formula =IF(Q8="0",0%,P8/Q8). * Cell P8 and *Q8 are formatted *as time (37:30:55) * If *cells P8 and Q8 equal 0:00:00 then my answer is #DIV/0!. *I want the answer to be 0.0% . *How do I do that? * *Thanks * |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dont want #DIV/0!.
duh, susan, try reading the formula first........
=IF(iserror(P8/Q8),"0%",(P8/Q8)) try that one instead. sorry! susan 3, 10:08*am, Susan wrote: =IF(iserror(Q8="0",0%,P8/Q8),"0",(Q8="0",0%,P8/Q8)) try that :) susan On Jan 3, 9:57*am, Wanna Learn wrote: This is my formula =IF(Q8="0",0%,P8/Q8). * Cell P8 and *Q8 are formatted *as time (37:30:55) * If *cells P8 and Q8 equal 0:00:00 then my answer is #DIV/0!. *I want the answer to be 0.0% . *How do I do that? * *Thanks *- Hide quoted text - - Show quoted text - |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Dont want #DIV/0!.
Try removing the "" around the 0. Adding "" will make an 'integer' appear as
'text' Regards, Ryan-- -- RyGuy "Wanna Learn" wrote: This is my formula =IF(Q8="0",0%,P8/Q8). Cell P8 and Q8 are formatted as time (37:30:55) If cells P8 and Q8 equal 0:00:00 then my answer is #DIV/0!. I want the answer to be 0.0% . How do I do that? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I dont want #N/A! | Excel Discussion (Misc queries) | |||
| Dont know if this is possible to do | Excel Discussion (Misc queries) | |||
| Dont know if this is possible to do | Excel Discussion (Misc queries) | |||
| Dont know what to use. | Excel Worksheet Functions | |||
| I know what I need but dont know how to do it | Excel Worksheet Functions | |||
Hybrid Mode
