Excel Formula

[grobertson]

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

Hi

Try this:
=(B2-A2)/A2

Andy


"grobertson" <[email protected]> wrote in message
news:[email protected]...
> 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

[Doug Kanter]

"grobertson" <[email protected]> wrote in message
news:[email protected]...
> 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.

[Dav]

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

Regards

Dav

[ewan7279]

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

[ewan7279]

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

[bpeltzer]

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

[Neil]

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