Results 1 to 3 of 3
  1. #1
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Forecast Function! (Excel 2002)

    I had a query the other day about Excels forcasting ability. The person mensioned they remember excel being used to forcast salary increases. They could not remember how it was done as it was some years agao that they used the spreadsheet! Immediately the FORECAST function cane to mind, but I was unsure of how it worked.

    Could someone explain and possibly attach an example of how to use this function. The excel help does not really show any great examples!!!!

    Cheers
    Regards,
    Rudi

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Forecast Function! (Excel 2002)

    See the attached workbook. Post back if you need more explanation.

  3. #3
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Forecast Function! (Excel 2002)

    Thanks Hans,
    This seems to answer a query I had. I think the chart also helps to let the penny drop.
    I will get back to the user with this working example.
    Cheers
    Regards,
    Rudi

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •