Dec 17 2021 11:18 AM
I followed a video and did exactly the same steps but when I press enter it comes up with the value error, what am I doing wrong?
Dec 17 2021 11:34 AM
=TREND(A4:A8,B4:B8,A10)
Without merged cells it works well in my spreadsheet. Try your formula without the merged cells C4:E8 and F4:H8.
Dec 17 2021 11:25 PM - edited Dec 17 2021 11:26 PM
@hollyh10 .... In D11, you can enter either of the following formulas:
=TREND($C$4:$C$8, $F$4:$F$8, D10)
or
=FORECAST(D10, $C$4:$C$8, $F$4:$F$8)
In this case, the TREND formula does __not__ need to be array-entered, since that use of TREND returns a single value (since D10 is a single cell), not an array of values (as it would for a range like D10:D20).
I prefer the FORECAST formula, because you do not require all the bells and whistles that TREND can provide. KISS.
For merged cells, refer to the upper-left cell. Do not refer to the range of cells that comprise "a" merged cell.