| Home |
| Search |
| Today's Posts |
|
#2
|
|||
|
|||
Using CORREL with arrays containing null values
You might incorporate an IF function, along the lines of
IF(ISNUMBER(your array function here),your array function here,0) It seems redundant, but it evaluates the array function to determine if it is numeric. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cntrl + down arrow and null values in cells | Excel Discussion (Misc queries) | |||
| Displaying null values in charts | Charts and Charting in Excel | |||
| Multipying columns that contail null values | Excel Discussion (Misc queries) | |||
| Problem with plotting a chart when using arrays as Values and Xvalues | Charts and Charting in Excel | |||
| Can I "CORREL" statistical funtion with three or more Arrays? | Excel Worksheet Functions | |||
Threaded Mode
