Display of LINEST results

[David Howdon]

When I use a the LINEST function and ask it to display the results
several of the cells in the output array are #N/A returns. Rightly I
suppose because there is supposed to be nothing in them so the LINEST
function is not appropriate there. However it looks messy. Is there a
way to make it output without these entries?

 

[Michael R Middleton]

David -

Maybe you could put LINEST inside the OFFSET function to display only the
output values of interest.

- Mike

www.mikemiddleton.com

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

 

[Jerry W. Lewis]

Alternately, you could use conditional formatting to change the font
color to the background color if the cell contains an error value.

Jerry

 

[David Howdon]

Alternately, you could use conditional formatting to change the font
color to the background color if the cell contains an error value.

Jerry

Thanks for these suggestions.