ROUND Function: Difference between revisions

From Planfix
Jump to: navigation, search
(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)


Go To