Error Using Returned Values as Input with Fourier AnalysisLast reviewed: September 2, 1997Article ID: Q114182 |
The information in this article applies to:
SYMPTOMSIn Microsoft Excel, when you use the Fourier Analysis tool, provided in the Analysis ToolPak add-in, to transform data in a worksheet, and you then use the Fourier Analysis tool again and you use values previously returned by this function as the new input range values, you receive the following error message:
Fourier Analysis - All complex numbers must have the same suffix, either "i" or "j".This behavior does not occur in Microsoft Excel version 4.0.
CAUSEThis behavior occurs because any non-imaginary number that is returned by the Fourier Analysis tool is formatted as a text value instead of number value. Because the Input Range value used in the Fourier Analysis tool must be formatted as a number, the error message appears when you use this returned value as an input value in the Fourier Analysis tool.
WORKAROUNDSTo avoid receiving this error message, do either of the following before using the Fourier Analysis tool using an input data range that has been returned by the Fourier Analysis tool:
REFERENCESFor more information about Fourier Analysis, choose the Search button in Help and type:
Fourier Analysis Tool |
Additional query words: 5.00 5.00c err msg addin addins toolpack tool
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |