Syntax: DFT(R)
R = a range representing a vector
DFT generates the Discrete Fourier Transform of the given range R. 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.
Example:
Vector C1..C4 =
| C | |
| 1 | 1.2 |
|---|---|
| 2 | 3.4 |
| 3 | 54.3 |
| 4 | 0.34 |
DFT(C1..C4) =
| 59.2 | 0 |
| -53.1 | 3.06 |
| 51.8 | 0 |
| -53.1 | -3.06 |
Excel function: N/A