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. |
#2
|
|||
|
|||
Difference
Try this: =1-(A1/B1)
Then format you cell with a custom format of something like this: +0.00;-0.00 ************ Anne Troy www.OfficeArticles.com "Sarah Talley" <Sarah wrote in message ... 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. |
#3
|
|||
|
|||
Difference
=(A1/B1)-1. Format as %.
"Sarah Talley" wrote: 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. |
#4
|
|||
|
|||
Difference
Just a head's up,
Your formula gives a positive %, but the OP was moving from 47 last year (B1) to 31 this year (A1). Maybe you missed which value is which. -- Regards, Tom Ogilvy "Anne Troy" wrote in message ... Try this: =1-(A1/B1) Then format you cell with a custom format of something like this: +0.00;-0.00 ************ Anne Troy www.OfficeArticles.com "Sarah Talley" <Sarah wrote in message ... 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. |
#5
|
|||
|
|||
Difference
Absolutely. :)
************ Anne Troy www.OfficeArticles.com "Tom Ogilvy" wrote in message ... Just a head's up, Your formula gives a positive %, but the OP was moving from 47 last year (B1) to 31 this year (A1). Maybe you missed which value is which. -- Regards, Tom Ogilvy "Anne Troy" wrote in message ... Try this: =1-(A1/B1) Then format you cell with a custom format of something like this: +0.00;-0.00 ************ Anne Troy www.OfficeArticles.com "Sarah Talley" <Sarah wrote in message ... 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. |
#6
|
|||
|
|||
Difference
sorry, what's OP?
"Anne Troy" wrote: Absolutely. :) ************ Anne Troy www.OfficeArticles.com "Tom Ogilvy" wrote in message ... Just a head's up, Your formula gives a positive %, but the OP was moving from 47 last year (B1) to 31 this year (A1). Maybe you missed which value is which. -- Regards, Tom Ogilvy "Anne Troy" wrote in message ... Try this: =1-(A1/B1) Then format you cell with a custom format of something like this: +0.00;-0.00 ************ Anne Troy www.OfficeArticles.com "Sarah Talley" <Sarah wrote in message ... 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. |
#7
|
|||
|
|||
Difference
It took me a long time to find that out, too. "Original Poster"--or at least
I think!! ************ Anne Troy www.OfficeArticles.com "Sarah Talley" wrote in message ... sorry, what's OP? "Anne Troy" wrote: Absolutely. :) ************ Anne Troy www.OfficeArticles.com "Tom Ogilvy" wrote in message ... Just a head's up, Your formula gives a positive %, but the OP was moving from 47 last year (B1) to 31 this year (A1). Maybe you missed which value is which. -- Regards, Tom Ogilvy "Anne Troy" wrote in message ... Try this: =1-(A1/B1) Then format you cell with a custom format of something like this: +0.00;-0.00 ************ Anne Troy www.OfficeArticles.com "Sarah Talley" <Sarah wrote in message ... 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. |
Reply |
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 |