Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Percentage differential in Excel

54 views
Skip to first unread message

David Ralston

unread,
Feb 5, 2003, 6:55:59 AM2/5/03
to
Hi,
Does anyone know how to set up Excel to calculate and display the %
differential between two numbers where one number is the base and the other
is the percentage difference from the base e.g. plus or minus 10 %? Is is
possible to get excell to display the figure as - or +10%?
Thanks for your help. David


Pieter Kuyck

unread,
Feb 5, 2003, 8:33:15 AM2/5/03
to
David,

Base in A1
Value in B1
C1=B1/A1-1 gives the difference from the base as a percentage (format the cell as percentage)

Pieter

"David Ralston" <da...@nospam.champs-elysees.com> wrote in message news:b1qu1h$2i2$1$8302...@news.demon.co.uk...

Peo Sjoblom

unread,
Feb 5, 2003, 8:42:33 AM2/5/03
to
Don't know if this is what you want?

A1 the base, B1 the other number

=(B1-A1)/100

format as percentage

--


Regards,


Peo Sjoblom


David Ralston <da...@nospam.champs-elysees.com> wrote in message
news:b1qu1h$2i2$1$8302...@news.demon.co.uk...

Jerry W. Lewis

unread,
Feb 5, 2003, 8:47:34 AM2/5/03
to
If you want to get the percent differential of 130 from a base of 150,
calculate =(130-150)/150 and format as a percentage to get -10%.

If that was not what you were asking, you might try rephrasing your
question for greater clarity.

Jerry

Peo Sjoblom

unread,
Feb 5, 2003, 9:46:19 AM2/5/03
to
Correction

=(B1-A1)/A1

--


Regards,


Peo Sjoblom


Peo Sjoblom <ter...@mvps.org> wrote in message
news:OXqajxRzCHA.2188@TK2MSFTNGP10...

Douglas M. Smith

unread,
Feb 5, 2003, 10:04:47 AM2/5/03
to
You can create a custom number format to show the
plus/minus characters. The custom format for ±10% is:

0%±1\0%

To enter the ± sign, hold down the Alt key and type 0177
from the numeric keypad.

Douglas M. Smith
Brainbench MVP for MS Excel
www.brainbench.com

>.
>

David Ralston

unread,
Feb 5, 2003, 10:50:35 AM2/5/03
to
Hi,
Thanks to everyone for their help.Your suggestons have solved the problem.
David

"David Ralston" <da...@nospam.champs-elysees.com> escribió en el mensaje
news:b1qu1h$2i2$1$8302...@news.demon.co.uk...

0 new messages