Hi
I have 3 calculations that have given 3 answers which I have converted to percentages. What calculation/formula do I need to get a mean average of the 3 calculations.
Can I also ask how I import data from another workbook?
Thanks in advance.
Hi
I have 3 calculations that have given 3 answers which I have converted to percentages. What calculation/formula do I need to get a mean average of the 3 calculations.
Can I also ask how I import data from another workbook?
Thanks in advance.
Hi,
Do you mean this
=AVERAGE(A1:A3)
or this
=MEDIAN(A1:A3)
With regard to importing data what do you mean exactly?
oldchippy
-------------
Blessed are those who can give without remembering and take without forgetting
If you are happy with the help you have received, please click the <--- STAR icon on the left - Thanks.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
Somehow, this looks strangly familiar...
Just a guess....
To "import" from one cell you could have both sheets open and press = and then point to the other workshooks cell.
Or, rightclick on the other workbooks sheets tab and select Move or Copy...
//Ola
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks