How to Use UNARY_PERCENT in Google Sheets in 2020?

UNARY_PERCENTReturns a value interpreted as a percentage; that is, `UNARY_PERCENT(100)` equals `1`.

Sample Usage

UNARY_PERCENT(A2)

UNARY_PERCENT(93)

Syntax

UNARY_PERCENT(percentage)

percentage – The value to interpret as a percentage.

Notes

UNARY_PERCENT is roughly equivalent to the inverse of TO_PERCENT.

See Also

TO_PERCENT: Converts a provided number to a percentage.

Examples