ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   constraints for the trend function (https://www.excelbanter.com/excel-discussion-misc-queries/97256-constraints-trend-function.html)

name

constraints for the trend function
 

I would like to forecast data, but have certain constraints that must be
satisfied. For example, I have time series volume data that is trending
downward, but I do not want the forecast to become negative. Is this
possible using the trend function? Also, is there a better way to
forecast than using the trend function? Any and all help is
appreciated.


--
name
------------------------------------------------------------------------
name's Profile: http://www.excelforum.com/member.php...o&userid=34115
View this thread: http://www.excelforum.com/showthread...hreadid=557741



All times are GMT +1. The time now is 03:38 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com