| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Try to find the difference by percentage between 2 cell totals
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find text within cell then display text to left | Excel Discussion (Misc queries) | |||
| how can I find out a total as a percentage using absolute cell | Excel Worksheet Functions | |||
| FORMAT PERCENTAGE IN INDEX CELL? | New Users to Excel | |||
| Percentage difference calc that knows the largest figure | Excel Discussion (Misc queries) | |||
| cell color index comparison | New Users to Excel | |||
Linear Mode
