Transform functions
Useful Microsoft Excel functions for transforming data.
| Transform | Excel function |
|---|---|
| Natural log | =LN(cell) |
| Inverse natural log | =EXP(cell) |
| Reciprocal | =1 / cell |
| Square root | =SQRT(cell) |
| Power | =cell^power |
| Log base 10 | =LOG(cell) or =LOG10(cell) |
| Inverse log base 10 | =10^cell |
| Log base 2 | =LOG(cell, 2) |
| Inverse log base 2 | =2^cell |
Related tasks