percent
percent(numerator,denominator)
The PERCENT function has the following arguments:
numeratorThe numerator value in the percentage calculation.
denominatorThe denominator value in the percentage calculation.
The percent function divides the numerator by the denominator, and multiplies the result by 100.
In case the denominator value is 0 the function will return 0.
|
Formula |
Description |
Result |
|---|---|---|
|
percent(9.9, 10) |
Percent value of 9.9/10 |
99.0 |
|
percent(0,16) |
Percent value of 0/16 |
0.0 |
|
percent(405,0) |
Percent value of 405/0. The invalid division is caught and the result is zero. |
0.0 |