 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / March 2006WHERE IS THE INTERPOLATION FUNCTION IN EXCEL 2003
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. In 2003, function [trend][growth], etc. can be used for forecast/interpolation. What is the function name you used on XL2000?  SignatureBest regards, --- Yongjun CHEN ================================= XLDataSoft - Data Analysis Expert, Excel/VBA Specialist - - - - www.XLDataSoft.com - - - - Free Excel-Based Data Processing Tool is Available for Download ================================= >I RECENTLY UPGRADED FROM EXCEL 2000 TO EXCEL 2003. IN EXCEL 2000, THERE >WAS [quoted text clipped - 4 lines] > OUT > THERE KNOWS WHERE I CAN FIND THIS FUNCTION. IF SO, PLEASE HELP. 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 > 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. The FORECAST() function does a great job of interpolation. See Excel Help. SignatureGary''s Student > 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. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.