Sunday, January 10, 2010

Find Cell Number How Do I Find Out A Percentage Change From One Cell To Another?

How do I find out a percentage change from one cell to another? - find cell number

I use Google Docs is good if it makes a difference, but I'm sure that it works like any spreadsheet.

I must, 1) Determine the percentage change from one cell to another and 2) determine the numerical change from one cell to another.

Thank you.

2 comments:

Jestr Rulz said...

Percentage change from A1 to B1
In Excel, it is = (A1-B1) / A1 (changes in the original)

The numerical change from A1 to B1
= A1-B1

billruss... said...

Huh?
numeric change is to be avoided
Share exchange rate (formatting per cent) to land use

For further information, if the numbers in A1 and B1, C1 and want the result to the formula in C1

Percent A1 B1: = A1/B1
C1-set format percent

Change: = A1-B1
.... o = B1-A1

Post a Comment