Display of LINEST results

  • Thread starter Thread starter David Howdon
  • Start date Start date
D

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?
 
Alternately, you could use conditional formatting to change the font
color to the background color if the cell contains an error value.

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

Jerry
Click to expand...

Thanks for these suggestions.
 
Back
Top