[SOLVED] Try to find the difference by percentage between 2 cell totals

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 OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...l-new/200606/1

see response in excel.misc.

--
HTH

Bob Phillips

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

"chedd via OfficeKB.com" <u18187@uwe> wrote in message
news:6174c06bd7e03@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 OfficeKB.com
> http://www.officekb.com/Uwe/Forums.a...l-new/200606/1