=TREND

[Builder]

Is there a way to get the =TREND formula to ignore blank rows?

 

[Dave Curtis]

Hi,

Yes, use =FORECAST instead.

I don't know why FORECAST allows blanks but TREND doesn't.

Dave

 

[Builder]

Thank you very much for the help.

Hi,

Yes, use =FORECAST instead.

I don't know why FORECAST allows blanks but TREND doesn't.

Dave