percentages

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

 

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

 

[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

 

[David Biddulph]

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.

 

[chedd via OfficeKB.com]

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

Thanks for your reply and will try the above.

 

[chedd via OfficeKB.com]

Change it to

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

Thanks it worked a treat