LINEST should optionally ignore incomplete data records
Submitted by an unknown user
Link to original bug (#551234)
Description
If a value in the x or y variables range is missing, LINEST considers that value 0 rather than ignoring the data point containg that value. (This is easy to see when one looks at the degree of freedom returned in the 2nd column of the fourht row when stats=TRUE.)
Version: git master