Basically based on the values I already have in both the A and B columns I need to extrapolate values for the unknown cells(I have also included the file to make any mistakes I may have made more easily visible), I am not sure how to actually do this on excel,I have tried the forecast formulas both they are all either ineffective or I have an error I cannot fix. Any help provided would be greatly appreciated.
I did 2 interpolations and 1 extrapolation (3 different formulas)
Is this what you expected ?
Kind regards,
Piet Bom
The results of the 'Forecast' function.
I don't understand what's wrong with this function ?
Thanks for the help I failed to include the dollar sign.
@porucha,
Forecast function is much better, you are right.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks