how do i find percentage from 2 different pages in Excel?
 

i AM WORKING WITH 2 SETS OF ANNUAL FIGURES AND i WOULD LIKE TO COMPARE THE
TWO BY PERCENTAGE. THE FIGURES ARE ALL IN THE SAME DOCUMENT BUT ON TWO
DIFFERENT SHEETS. HOW WOULD I SET UP A SHEET THAT WOULD ALLOW ME TO DO THIS?

Hi fp
If your data is in Sheet 1 cell A1 and Sheet 2 B1 for example.
Setup a new sheet and put in the formula:

=Sheet1!A1/Sheet2!B1

HTH
Michael

"fpbuckland" wrote:

i AM WORKING WITH 2 SETS OF ANNUAL FIGURES AND i WOULD LIKE TO COMPARE THE
TWO BY PERCENTAGE. THE FIGURES ARE ALL IN THE SAME DOCUMENT BUT ON TWO
DIFFERENT SHEETS. HOW WOULD I SET UP A SHEET THAT WOULD ALLOW ME TO DO THIS?