From: T. Valko on 7 Mar 2010 23:18
Try it like this...
Microsoft Excel MVP
"painter50" <painter50(a)discussions.microsoft.com> wrote in message
> This is the formulas I trying to fix
> 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)
> "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
>> show the total of these cell to be 0 when not used?