I am trying to produce a report between 2 sheets to show the difference
between two cell totals by a percentage plus state to whether there is an
increase/decrease or the same . The formula to obtain the percentage I am
using is B9/'Apr 06 monthly report'!B9, but do to my lack of knowlege in this
area i would appreciate some ideas on a formula to help with my query?

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

try using normal log:
=LN(B9/'Apr 06 monthly report'!B9)

this immediately gives the change in percentage and direction of change.
e.g. LN(95/100)= -0.05

ciao



"chedd via OfficeKB.com" wrote:

I am trying to produce a report between 2 sheets to show the difference
between two cell totals by a percentage plus state to whether there is an
increase/decrease or the same . The formula to obtain the percentage I am
using is B9/'Apr 06 monthly report'!B9, but do to my lack of knowlege in this
area i would appreciate some ideas on a formula to help with my query?

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

see response in excel.,misc, no need to pots everywhere we see them all.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:6174ee1f6a749@uwe...
I am trying to produce a report between 2 sheets to show the difference
between two cell totals by a percentage plus state to whether there is an
increase/decrease or the same . The formula to obtain the percentage I am
using is B9/'Apr 06 monthly report'!B9, but do to my lack of knowlege in
this
area i would appreciate some ideas on a formula to help with my query?

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