$DIV/0!

[carl]

I have some cells that have 0 in them. Is there a way to
have the cell in the denominator but not return the
$DIV/0! ?

Thank you in advance.

 

[Harlan Grove]

I have some cells that have 0 in them. Is there a way to
have the cell in the denominator but not return the
$DIV/0! ?

No. You'd need to wrap your formula inside an IF function, e.g.,

=B2/C2 -> =IF(C2<>0,B2/C2,"") or just =IF(C2,B2/C2,"")

 

[dlassalle]

C21 D21 E21 F21
100,000 0 (100,000) 0.0% 191,800

100,000 15,000 (85,000) (566.7%) 60,000

=IF(ISERROR(+E15/D15),"-",+E15/D15) IN CELL F21.

HOPE THIS COMES THRU.

CDL