Percentage problems
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...excel/200606/1 |
Percentage problems
=B9/'Apr 06 monthly report'!B9&IF(B9'Apr 06 monthly report'!B9,"
increase"," decrease") -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "chedd via OfficeKB.com" <u18187@uwe wrote in message news:6174c9edd083d@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...excel/200606/1 |
All times are GMT +1. The time now is 02:50 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com