Thread: Dont want #DIV/0!.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Wanna Learn Wanna Learn is offline
external usenet poster
  
Posts: 318
Default 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
Reply With QuoteReply With Quote