ROUND Function: Difference between revisions
From Planfix
(Created page with "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 c...") |
No edit summary |
||
| (One intermediate revision by one other user not shown) | |||
| 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: | ||
ROUND(A;2) | ROUND(A;2) | ||
| Line 17: | Line 25: | ||
ROUND(A;2) | ROUND(A;2) | ||
ROUND({{Task.Number field}};2) | ROUND(<nowiki>{{Task.Number field}}</nowiki>;2) | ||
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)