How to apply the 'FORECAST' function in spreadsheet?

[MarcAI]

Hello,

I'm attempting to apply the 'FORECAST' function to forecast a row of numbers 0 to 3. I selected a row of numbers to forecast. I then receive the following prompt:

The formula you entered contains errors. If you do not wish to use a formula, insert a single quotation-mark before your text.

What are the steps to applying the 'FORECAST' function?

Thank-you

 

[rgd1101]

https/support.office.com/en-us/article/Create-a-forecast-in-Excel-2016-for-Windows-22c500da-6da7-45e5-bfdc-60a7062329fd

 

[MarcAI]

ADDENDUM to original post: How is the 'FORECAST' function applied in the Kingsoft Spreadsheet?

 

[rgd1101]

kingsoft don't have help file?

 

[rgd1101]

so hard to find anything for this
http/www.ksosoft.com/spreadsheets/648-what-are-the-statistical-functions-in-spreadsheets-2013.html
3 variable
FORECAST (x, known_y’s, known_x’s)

similar to this
http/www.quepublishing.com/articles/article.aspx?p=469493