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)
 
B

Bob Phillips

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

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
C

Chip Pearson

Change it to

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


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
D

David Biddulph

chedd via OfficeKB.com said:
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)
Click to expand...

You've had the answer in the thread you started on 9th June.
 
Top