Name

percent — Return the first value as a percentage of the second number.

Syntax

percent(numerator, denominator)
              

The PERCENT function has the following arguments:

numerator

The numerator value in the percentage calculation.

denominator

The denominator value in the percentage calculation.

Description

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.

Examples

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