Get instant live expert help on I need help with excel interpolate function
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
How to use an Excel Series feature to Interpolate for a problem
Solved by O. D. in 20 mins
How to use an Excel Series feature to Interpolate for a problem.
income from home sales in Year 3 through Year 10
Solved by M. L. in 18 mins
Enter 149.0 in E12 and 67.0 in M12. Use the Excel Series feature to Interpolate the income from home sales in Year 3 through Year 10. Enter 0 for years 11 to 15 in cells N12:R12
Solved by K. H. in 29 mins
I'm working on a large sheet, trying to make a contour map for my house block.
Something has happened to basic excel logic. E.g. autofill dragging a simple number list, descending by 0.1, corrupts after 10-20 lines and starts subtracting 0.00000000000001 (14 decimal points) randomly, so failing match results.
I also think I'm creating a formula poorly, as I'm a rookie user. Interpolate is doing X or Y, not both at once.
Questions:
Can you help me solve dragging calculation bug, improve my formula, and suggest any better interpolate formula?
Solved by K. S. in 27 mins
maintenance fees are expected to produce 0.22 million in Year 2 and increase on a growth trend through Year 15 to a final value of 6.7 million. Enter 0.22 in E13 and 6.7 in R13. Use the Excel Series feature to Interpolate in income from vendor fees in Year 3 through Year 15.
Solved by C. C. in 13 mins