| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
function cell range limitations
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 ? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Displaying value of specific cell within a range, with IF function...? | Excel Discussion (Misc queries) | |||
| How can I shift cell range contents by using a function? | Excel Worksheet Functions | |||
| which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
| which formula or function searches for a value in a range of cell. | Excel Worksheet Functions | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
