#DIV/O!
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
|