lorenambrose
Active Member
- Joined
- Sep 17, 2008
- Messages
- 265
Hello All,
I have a run chart and it includes a trend line. In the spresdsheet I use a LINEST function to give the trend line its value. I am using this value to make an automatic entry of
"FLAT"
"MODERATE"
"MAJOR"
Everything works EXCEPT when the column of numbers has empty cells. This is going to be expected with my data and I need to know how I can get the LINEST function to ignore empty cells.
I have a run chart and it includes a trend line. In the spresdsheet I use a LINEST function to give the trend line its value. I am using this value to make an automatic entry of
"FLAT"
"MODERATE"
"MAJOR"
Everything works EXCEPT when the column of numbers has empty cells. This is going to be expected with my data and I need to know how I can get the LINEST function to ignore empty cells.