![]() |
WHERE 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. |
WHERE IS THE INTERPOLATION FUNCTION IN EXCEL 2003
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 ================================= "Cooper" wrote in message ... 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. |
WHERE IS THE INTERPOLATION FUNCTION IN EXCEL 2003
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 "Cooper" wrote: 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. |
WHERE IS THE INTERPOLATION FUNCTION IN EXCEL 2003
The FORECAST() function does a great job of interpolation. See Excel Help.
-- Gary''s Student "Cooper" wrote: 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. |
All times are GMT +1. The time now is 12:00 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com