Try it like this...

=IF(Q5=0,"-",(I5-P5)/Q5)

--
Biff
Microsoft Excel MVP


"painter50" wrote in message
...
This is the formulas I trying to fix

=(I5-P5)/Q5
I5=0 P5=0 Q5=0

I used =IF(ISERROR(I5-P5),"-",I5-P5) and it worked fine. The problem is
when I try to divide the (I5-P5)
Joe


"painter50" wrote:

I get this #DIV/O! when I divide two cell that both total 0.

These cell will not always be used in the spreadsheet. Is there any way
to
show the total of these cell to be 0 when not used?
--
Joe