EXP
The EXP function returns e raised to the power of a given number. This is the reverse of ln, the natural logarithm of number.
Syntax
EXP(value) - > number
Arguments
value
Number, Node reference
The exponent applied to the base e. This is a required argument.
Example
Consider a scenario where we have the 2020 population figures of 5 major cities. Our goal is to estimate the population in the year 2030 assuming an average growth rate of 2%.
City
New York
London
Hongkong
Toronto
Los Angeles
2020 population
8804190
9002488
7960000
3998747
6197000
Growth rate
0.02
0.02
0.02
0.02
0.02
Duration
10
10
10
10
10
To achieve this, the following formula should be written in the [2030 population] node:
[2020 population]*EXP([Growth rate]*[Duration])
Result
10753461.95
10995663.67
9722365.955
4884080.615
7569032.892
Last updated