close

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?

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

=================================
quot;Cooperquot; gt; wrote in message
...
gt;I RECENTLY UPGRADED FROM EXCEL 2000 TO EXCEL 2003. IN EXCEL 2000, THERE
gt;WAS
gt; AN ENGINEERING FUNCTION CATAGORY AND IN THIS CATAGORY THERE WAS AN
gt; INTERPOLATION FUNCTION. I USE THIS FUNCTION ALL THE TIME AND WHEN I TRIED
gt; TO
gt; USE IT IN EXCEL 2003, IT SAID IT WAS UNDEFINED. I DO NOT KNOW IF ANYBODY
gt; OUT
gt; 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-gt;Add-ins... and check Analysis Toolpak

quot;Cooperquot; wrote:

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

The FORECAST() function does a great job of interpolation. See Excel Help.
--
Gary''s Studentquot;Cooperquot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()