Dont want #DIV/0!.

W

Wanna Learn

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
 
R

ryguy7272

Try removing the "" around the 0. Adding "" will make an 'integer' appear as
'text'

Regards,
Ryan--
 
S

Susan

duh, susan, try reading the formula first........

=IF(iserror(P8/Q8),"0%",(P8/Q8))

try that one instead.
sorry!
susan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

General Calculator 1
Why doesn't this nested IF statement work? 4
Using formulas from Quattro Pro in Excel 2007 4
#DIV/0! error 1
Search for Text within a Formula Result Q 5
HELP!! I need help w/Conditional Formatting 2
Calculating %'s with IF and Sum/SumIF 12
combining Formulas 2

Top