percentages
 

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

percentages
 

=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

percentages
 

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

percentages
 

"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

percentages
 

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

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)


Thanks for your reply and will try the above.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1

percentages
 

Chip Pearson wrote:
Change it to

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

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)


Thanks it worked a treat

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200606/1