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?
|