Forcing DIV/0 to display "0"

[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

 

[Bondi]

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

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

 

[Pieter van der Walt]

Thanks Bondi - got it working!!

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