Excel Formula
 

Hi,
I have two columns of numbers
A B C
1 103,956.09 119,894.84

What I would like is a formula in Cell C1 that will show a percentage
increase of cell B1 on A1.

Many Thanks
Glenn

Excel Formula
 

Hi

Try this:
=(B2-A2)/A2

Andy


"grobertson" wrote in message
...
Hi,
I have two columns of numbers
A B C
1 103,956.09 119,894.84

What I would like is a formula in Cell C1 that will show a percentage
increase of cell B1 on A1.

Many Thanks
Glenn

Excel Formula
 

"grobertson" wrote in message
...
Hi,
I have two columns of numbers
A B C
1 103,956.09 119,894.84

What I would like is a formula in Cell C1 that will show a percentage
increase of cell B1 on A1.

Many Thanks
Glenn

Begin by writing down the formula as if you were showing it to a high school
student. Show us what you come up with.

Excel Formula
 

=(B1-A1)/A1 and format as a percentage

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=507689

Excel Formula
 

Glenn,

In C1, enter: =(B1-A1)/A1

Ewan

"grobertson" wrote:

Hi,
I have two columns of numbers
A B C
1 103,956.09 119,894.84

What I would like is a formula in Cell C1 that will show a percentage
increase of cell B1 on A1.

Many Thanks
Glenn

Excel Formula
 

Sorry - must format too,

In C1 enter: =(B1-A1)/A1

then format the cell by going to Format=Cells=Percentage

"grobertson" wrote:

Hi,
I have two columns of numbers
A B C
1 103,956.09 119,894.84

What I would like is a formula in Cell C1 that will show a percentage
increase of cell B1 on A1.

Many Thanks
Glenn

Excel Formula
 

In cell C1: =b1/a1 - 1. Format as a percentage

"grobertson" wrote:

Hi,
I have two columns of numbers
A B C
1 103,956.09 119,894.84

What I would like is a formula in Cell C1 that will show a percentage
increase of cell B1 on A1.

Many Thanks
Glenn

Excel Formula
 

If you want the result to display as a percentage also format cell C1 as a
percentage.

HTH

Neil
www.nwarwick.co.uk

"ewan7279" wrote:

Glenn,

In C1, enter: =(B1-A1)/A1

Ewan

"grobertson" wrote:

Hi,
I have two columns of numbers
A B C
1 103,956.09 119,894.84

What I would like is a formula in Cell C1 that will show a percentage
increase of cell B1 on A1.

Many Thanks
Glenn