PERCENTAGES

[chedd via OfficeKB.com]

Hi can anyone help as i keep getting error message #DIV/0! in the cells
The formula i have is =IF(B45=0,"0%",B45/'Apr 06 monthly report'!B45)

Thanks

 

[Ardus Petus]

Maybe cell B45 in sheet 'Apr 06 monthly report' is empty or zero ?

HTH

 

[chedd via OfficeKB.com]

Yes the B45 does have zero conection, but just wondering if the cell could
regeister a fig instead of an error message for reports?

 

[Ardus Petus]

=IF(OR(B45=0,'Apr 06 monthly report'!B45),"0%",B45/'Apr 06 monthly
report'!B45)

That will return 0% if 'Apr 06 monthly report'!B45=0

 

[chedd via OfficeKB.com]

=IF(OR(B45=0,'Apr 06 monthly report'!B45),"0%",B45/'Apr 06 monthly
report'!B45)

That will return 0% if 'Apr 06 monthly report'!B45=0

--
AP

Yes the B45 does have zero conection, but just wondering if the cell could
regeister a fig instead of an error message for reports?

[quoted text clipped - 9 lines]

I have tried the formula above, but either still get the same error or if i
copy the formula into another cell it return 0% instead of a fig that was
there before.