• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Forecasting and Targets on Excel

Y

yipbop

New Member
Hi, I was wondering if there is a formula to use in excel that would give me a forecast based on the targets I enter. For example, for 2010 H2, I have # Leads, # Opportunities target and I need to show a gradual increase in a six month period. so instead of me setting the target after forecasting monthly, the target is set and the monthly targets are created.


Thanks, Yip
 
You can use Forecast

ie: `=Forecast(10,{2,3},{4,5}) = 8

It is using 2 points (2,4) and (3,5) and calulates the Y for the value of x of 10


or you can use ranges:

Code: 
=Forecast(10, A2:A10, B2:B10)


or


If you have a simple increase based on say a known % increase per period you can use

=CV*power((1+r),Periods)

CV= Current value

r= Increase per period

Periods = No. of periods
 
You must log in or register to reply here.
Back
Top