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

"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