ROUND Function: Difference between revisions
From Planfix
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
{{#seo: | |||
|title=ROUND Function | |||
|titlemode=append | |||
|keywords=planfix, Function, ROUND, report | |||
|description=ROUND Function | |||
}} | |||
The ROUND function rounds numbers to the specified number of digits. For example, if column A contains the number 23.7825 and you need to round it to two decimal places, you can use the following formula: | The ROUND function rounds numbers to the specified number of digits. For example, if column A contains the number 23.7825 and you need to round it to two decimal places, you can use the following formula: | ||
Latest revision as of 07:52, 10 May 2024
The ROUND function rounds numbers to the specified number of digits. For example, if column A contains the number 23.7825 and you need to round it to two decimal places, you can use the following formula:
ROUND(A;2)
As a result, you'd get the number 23.78.
Format:
ROUND(number;num_digits)
Examples:
ROUND(A;2)
ROUND({{Task.Number field}};2)