Forcing DIV/0 to display "0"

  • Thread starter Pieter van der Walt
  • Start date
P

Pieter van der Walt

I have a scorecard in Excel 2003 and instead of having DIV/0 errors
displayed is there a way of actually forcing it to display a zero/null
value? I had a looked at conditional formatting and the example only seems
to be hiding it in a different colour.

Thanks
Pieter
 
B

Bondi

Pieter said:
I have a scorecard in Excel 2003 and instead of having DIV/0 errors
displayed is there a way of actually forcing it to display a zero/null
value? I had a looked at conditional formatting and the example only seems
to be hiding it in a different colour.

Thanks
Pieter
Click to expand...

Hi Pieter,

One way would be to use ISERROR. SOmething along the lines of

=IF(ISERROR(A1/B1),0,A1/B1)

Where the numbers in the operation is in A1 and A2..

Another would be to tjeck if the denominator is zero something like:

=IF(B1=0,0,A1/B1)

Regards,
Bondi
 
P

Pieter van der Walt

Thanks Bondi - got it working!!


Bondi said:
Hi Pieter,

One way would be to use ISERROR. SOmething along the lines of

=IF(ISERROR(A1/B1),0,A1/B1)

Where the numbers in the operation is in A1 and A2..

Another would be to tjeck if the denominator is zero something like:

=IF(B1=0,0,A1/B1)

Regards,
Bondi
Click to expand...
 
Top