Forcing DIV/0 to display "0"
 

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

Forcing DIV/0 to display "0"
 

Pieter van der Walt wrote:
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

Forcing DIV/0 to display "0"
 

Thanks Bondi - got it working!!


"Bondi" wrote in message
oups.com...

Pieter van der Walt wrote:
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