In MS-Excel, a straight line is created which connects two known values, and thereby future value is calculated using simple mathematics formula or using FORECAST function.There can bé times whén it becomes difficuIt to memorize thé formula.Now let us see how we use the FORECAST function when the knownys and knownxs are calculated using OFFSET and MATCH function.
For value 1, MATCH function will find the largest value that is less than or equal to the lookupvalue, and the value should be in ascending order. For the vaIue -1, function will find the smallest value that is greater than or equal to the lookupvalue and the value should be in descending order. Columns in MATCH function, i.e. Similarly, we can estimate the sales of the firm for a different number of days using this FORECAST function. Here we discuss How to Interpolate in Excel along with practical examples and downloadable excel template. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |