How to forecast a currency amount without dates

The function takes three arguments.

1. An x value for which you want to know a y value
2. A y range of dependent known values
3. An independent x range of known values


You don't have all the information to calculate using a Forecast function.

Perhaps explain what you are trying to demonstrate.

Assuming that this is linear, B1 to B10 are 1 to 10

Formula:

Please Login or Register  to view this content.

will give you forecast of 1584.64