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