Excel Formula

G

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
 
D

Doug Kanter

grobertson said:
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
Click to expand...

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

ewan7279

Sorry - must format too,

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

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