I am trying to create FORECAST.ETS function in Excel Online but it returns #N/A error. According to documentation, this happens when the ranges of two arguments (timeline and values) are not of the same size. However, my ranges are of the same size., my timeline is like: January 1st, February 1st, March 1st etc. Any idea what I am doing wrong? My formula is like this: =FORECAST.ETS(A13,$B$2:$B$12,$A$2:$A$12,1,1,1)
Hi,
At a first glance your formula looks OK. Possibly there is something wrong in your data but can't judge that without more info.
Share a sample of your workbook and add it as attachment.
That will give us a better opportunity to help you.
HtH,
Joris
--------------------------------------------------------------------------------
If you found my answer helpful, please hit the Like or Thank button.
Please follow the forum Rules and Guidelines and use Code tags around your VBA code.
Remember: test VBA code always on a copy of your file because usually you can't use undo
The dates need to be Excel dates, not text that looks (somewhat) like a date. If you format them as General, they should appear as numbers.
Entia non sunt multiplicanda sine necessitate
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks