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

You've had the answer in the thread you started on 9th June.
--
David Biddulph