| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Difference
A similar question was asked about a year ago, but I didn't quite get the
answer I needed. I have a statistical spreadsheet. What I'm trying to do is show the percentage increase/decrease of incidents in comparison to the previous year. Eg: A1= 31(this years numbers) B1=47(last years numbers) in C1 I want to display either -#% or +#% (depending on if the numbers have increased or decreased compared to the previous year) Someone gave the formula =(A1/B1)/A1 but I don't think that's quite right. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula to find the working days difference between to dates? | Excel Discussion (Misc queries) | |||
| Calculating Time difference based on a condition | Excel Discussion (Misc queries) | |||
| Date difference | Excel Worksheet Functions | |||
| charting a difference of 2 columns' w/o adding a difference column | Charts and Charting in Excel | |||
| How to get difference in hours | Excel Worksheet Functions | |||
Threaded Mode
