Prev: Future date with six day week including holidays
Next: vlookup 3 sheets
From: T. Valko on 7 Mar 2010 23:18
Try it like this...

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

--
Biff
Microsoft Excel MVP


"painter50" <painter50(a)discussions.microsoft.com> wrote in message
news:C18A670C-0396-4FDC-A228-274A5A2CE9F6(a)microsoft.com...
> 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


First  |  Prev  | 
Pages: 1 2
Prev: Future date with six day week including holidays
Next: vlookup 3 sheets