ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Percentages between two cells (https://www.excelbanter.com/excel-worksheet-functions/92833-percentages-between-two-cells.html)

chedd via OfficeKB.com

Percentages between two cells
 
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...tions/200606/1

Bob Phillips

Percentages between two cells
 
For God's sake, enough is enough, we have seen this post dozens of times
already.

--
HTH

Bob Phillips

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

"chedd via OfficeKB.com" <u18187@uwe wrote in message
news:6174dfc320784@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...tions/200606/1





All times are GMT +1. The time now is 02:16 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com