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


"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:61a8448de9bf1@uwe...
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)

--
Message posted via http://www.officekb.com