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

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 *

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

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 -