I am currently forecasting percentages for future dates for work going up and down, but when I use the Trend formula the percentages either go over 100% or below 0% into a negative.
I know that there is the Min function to cap it, but I can't quite get this to work the way that I want and I can't really find any other alternatives.
Example below
Formula
=TREND($A$8:C8,$A$7:C7,D7)
Data
31/01/2021 01/02/2021 02/02/2021 03/02/2021 04/02/2021 05/02/2021 06/02/2021 07/02/2021
10% 5% 2% -2.33% -6.33% -10.33% -14.33% -18.33%
31/01/2021 01/02/2021 02/02/2021 03/02/2021 04/02/2021 05/02/2021 06/02/2021 07/02/2021
70% 80% 98% 110.67% 124.67% 138.67% 152.67% 166.67%
Bookmarks