Percentage Plus or Minus

[Bugalugs]

I'm comparing results month on month but want to show it as a percentage - I
think that I'm overly confusing myself but I want to show whether it's a plus
or minus from the month before. It would also be lovely to show plus in
green and minus in red!

 

[Bernard Liengme]

The formula you need is (this-month - last-month)/last-month as in
=(B1-A1)/A1
You could then use a custom format such as [Green]0%;[Red]-0% for the
colouring
best wishes

 

[Chip Pearson]

If your previous month's value is in A2 and the current month value is
in B2, use

=(B2-A2)/A2

Use the Percent format or, if you want the + sign for positive values,
use a custom number format as "+0%;-0%".

Cordially,
Chip Pearson
Microsoft MVP
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[Bugalugs]

Thanks so much! Do I just tag the custom format onto the end of the % formula?

The formula you need is (this-month - last-month)/last-month as in
=(B1-A1)/A1
You could then use a custom format such as [Green]0%;[Red]-0% for the
colouring
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm comparing results month on month but want to show it as a percentage -
I
think that I'm overly confusing myself but I want to show whether it's a
plus
or minus from the month before. It would also be lovely to show plus in
green and minus in red!

 

[David Biddulph]

No, you don't put it at the end of the formula, it's a "custom format", as
Bernard said. If you don't undestand custom formats, type the term "custom
format" into Excel help.
--
David Biddulph

Thanks so much! Do I just tag the custom format onto the end of the %
formula?

The formula you need is (this-month - last-month)/last-month as in
=(B1-A1)/A1
You could then use a custom format such as [Green]0%;[Red]-0% for the
colouring
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm comparing results month on month but want to show it as a
percentage -
I
think that I'm overly confusing myself but I want to show whether it's
a
plus
or minus from the month before. It would also be lovely to show plus
in
green and minus in red!

 

[Bugalugs]

Fab - thanks so much for a prompt response David!

No, you don't put it at the end of the formula, it's a "custom format", as
Bernard said. If you don't undestand custom formats, type the term "custom
format" into Excel help.
--
David Biddulph

Thanks so much! Do I just tag the custom format onto the end of the %
formula?

The formula you need is (this-month - last-month)/last-month as in
=(B1-A1)/A1
You could then use a custom format such as [Green]0%;[Red]-0% for the
colouring
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

I'm comparing results month on month but want to show it as a
percentage -
I
think that I'm overly confusing myself but I want to show whether it's
a
plus
or minus from the month before. It would also be lovely to show plus
in
green and minus in red!