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 |
||
| Line 1: | Line 1: | ||
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 18: | ||
ROUND(A;2) | ROUND(A;2) | ||
ROUND({{Task.Number field}};2) | ROUND(<nowiki>{{Task.Number field}}</nowiki>;2) | ||
Revision as of 04:39, 11 December 2019
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)