# FORECAST Function Guidance

#### mrhartley

##### Well-known Member
Hi,

Just stumbled across the FORECAST function a couple of days ago and was hoping that someone can explain the basics for me (maybe via a guide) or point out how might I use FORECAST in the following simple example.

I have tried it myself and I think I have been successful but I am looking for clarification.

example 1 - in column I3 I would like to forecast the next % base don the previous %
DTMA Trend.xls
BCDEFGHI
3Test KPI90.00%90.54%96.05%94.19%92.45%95.06%
Sheet1

example 2
forecast.xls
BCDEFGHI
11234567
3Test KPI90.00%90.54%96.05%94.19%92.45%95.06%95.97%
Sheet1

Have I got it right?

Thanks In Advance for any pointers. Like I say, just found this function and would like to try an take advantage of it more.
Regards
~Mark

### Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

~Mark

#### mrhartley

##### Well-known Member
They were good thanks.

That taught me that not only will FORECAST predict the next iteration based on a pair of numbers but will also predict when a target might be reached.

EDIT -With Simple Example
forecast.xls
CDEF
8DateWeight24/10/2006
905/08/200689predicted date for ideal weight of 70 kilos
1012/08/200687
1119/08/200685
1226/08/200684
1302/09/200682
1409/09/200681
1516/09/200679
1623/09/200677
1730/09/200676
1807/10/200674
19what I will weigh on the 7th october
Sheet1

Thanks again
~Mark

Replies
0
Views
552
Replies
3
Views
420
Replies
0
Views
1K

1,172,173
Messages
5,879,463
Members
433,434
Latest member
skk0048

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back