PERCENTAGES

  • Thread starter chedd via OfficeKB.com
  • Start date
C

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
 
C

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?
 
A

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
 
C

chedd via OfficeKB.com

Ardus said:
=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?
Click to expand...
[quoted text clipped - 9 lines]
Click to expand...


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.
 
Top