WHERE IS THE INTERPOLATION FUNCTION IN EXCEL 2003

[Guest]

I RECENTLY UPGRADED FROM EXCEL 2000 TO EXCEL 2003. IN EXCEL 2000, THERE WAS
AN ENGINEERING FUNCTION CATAGORY AND IN THIS CATAGORY THERE WAS AN
INTERPOLATION FUNCTION. I USE THIS FUNCTION ALL THE TIME AND WHEN I TRIED TO
USE IT IN EXCEL 2003, IT SAID IT WAS UNDEFINED. I DO NOT KNOW IF ANYBODY OUT
THERE KNOWS WHERE I CAN FIND THIS FUNCTION. IF SO, PLEASE HELP.

 

[Daniel CHEN]

In 2003, function [trend][growth], etc. can be used for
forecast/interpolation.
What is the function name you used on XL2000?

--
Best regards,
---
Yongjun CHEN
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download

=================================

 

[Guest]

1) Please don't post in all CAPS - it's the equivalent of shouting
2) most likely you need to go to Tools->Add-ins... and check Analysis Toolpak

 

[Guest]

The FORECAST() function does a great job of interpolation. See Excel Help.