Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IS THERE AN INTERPOLATION FUNCTION IN EXCEL 2003 | Excel Worksheet Functions | |||
Excel 2003, Insert Function, create full name & descriptions | Excel Worksheet Functions | |||
Excel 2003: can I insert a "last edited" date function? | Excel Worksheet Functions | |||
WHY WAS THE CONVERT FUNCTION DROPPED IN EXCEL 2003??? | Excel Worksheet Functions | |||
CHR() function not working in Excel 2003 | Excel Discussion (Misc queries) |