AXA -

Three issues:

(1) Which version of Excel?

(2) Please provide data (as a list of values in a message, not as an
attachment) with instructions for replicating results that are not valid.

(3) Have you looked at an XY (Scatter) chart of the data to verify that the
CORREL measure of linear (straight line) relationship is appropriate?

- Mike

www.mikemiddleton.com

+++++++++++++++++++++++

"AXA" wrote in message
...
In using the CORREL(correlation) function, which correlates data over 2
cell
ranges, I have found that if the number of cells in each range is 14 or
less,
the results are valid, for both whole and decimal numbers. However, if
the
number of cells in each range is 15 or greater, the results are NOT valid
for
decimals, but remain valid for whole numbers. Note that for CORREL both
ranges must have the same number of cells.
Any thoughts on what is being missed here ?