In m/s Excell 2002 I am trying to find a formula & need help?

4 ⤊

In m/s Excell 2002 I am trying to find a formula & need help?

I'm using Excell 2002 (office XP pro) and I need to find a formula to express the difference between two cells and show this as a + or - percentage. Anyone have any suggestions

2007-10-26 03:29:38 · 2 answers · asked by COLIN H 2 in Computers & Internet ➔ Programming & Design

2 answers

If two cells are 'A1' and 'B1' then in 'C1' '=(A1-B1)/B1', then format cell as percent. (dont type in the ' marks)

2007-10-26 03:35:56 · answer #1 · answered by Wayne G 3 · 4⤊ 0⤋

If the two cells are A1 and B1, and you want to know what the percentage difference is from the value in A1, then you need to divide by A1, not B1.

So, into C1, you put: =(A1-B1)/A1
and then you format as a percentage.

2007-10-26 04:55:03 · answer #2 · answered by chrisjbsc 7 · 0⤊ 0⤋