UNARY_PERCENT
Description
Returns the specified number divided by 100. The appearance of the returned result depends
on the Format setting for the cell.
Syntax
UNARY_PERCENT(
number
)
- number: The number to divide by 100. A null value returns 0. A string or date value is converted to a number and divided by 100.
Example
Formula | Result |
|---|---|
=UNARY_PERCENT(A1)
Where cell A1 contains
1.1123
.
| 0.01123 |
=UNARY_PERCENT(A1)
Where cell A1 contains
32.255%
.
| 0.0032255 |