Syntax: INVDFT(R)
R = a range
INVDFT generates the inverse Discrete Fourier Transform of the range R. Like DFT, R must represent a real vector (either its row or column dimension must be 1), or a complex vector (either its row or column dimension must be 2). The result is always a complex vector.
Examples:
A | B | |
1 | 0.99 | 0 |
---|---|---|
2 | 3 | 6.2 |
3 | 4.1 | 1.1 |
4 | 3.3 | 6.3 |
With INVDFT(A1..B4) in B6 gives:
B | C | |
6 | 2.8475 | 3.4 |
---|---|---|
7 | -0.8025 | -0.2 |
8 | -0.3025 | -2.85 |
9 | -0.7525 | -0.35 |
INVDFT(G4..I6) = Error - INVDFT, improper dimensions
Excel function: N/A