$DIV/0!

  • Thread starter Thread starter carl
  • Start date Start date
C

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.
 
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! ?
Click to expand...

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,"")
 
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
 
Back
Top