This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
- 4D View Pro Reference
-
- 4D View Pro Formulas
-
-
Operators and values
-
Cell references
-
Converting 4D View plug-in formulas
-
ABS
-
ACOS
-
AND
-
ASIN
-
ATAN
-
AVERAGE
-
COLUMNLETTER
-
COS
-
COUNTA
-
EXP
-
FALSE
-
FINDCELL
-
FV
-
IF
-
INDIRECT
-
ISBLANK
-
LEN
-
LN
-
LOOKUP
-
MAX
-
MID
-
MIN
-
NOT
-
NOW
-
NPER
-
OR
-
PI
-
PMT
-
PV
-
RAND
-
RATE
-
ROUND
-
ROW
-
RUNTIME_CURRENT_TIME
-
RUNTIME_DATE
-
RUNTIME_STRING
-
RUNTIME_TIME
-
RUNTIME_VIEW_STRING
-
SIN
-
SQRT
-
STDEV.P
-
SUBSTITUTE
-
SUM
-
TAN
-
TEXT
-
TODAY
-
TRUE
-
TYPE
-
VAR.P
-
4D v19
ROUND
ROUND
| ROUND ( value , places ) | ||||||||
| Parameter | Type | Description | ||||||
| value | Number |
|
Number to round | |||||
| places | Number |
|
Number of decimal places | |||||
The ROUND function rounds the specified value to the nearest number, using the specified number of decimal places.
Use the value parameter to specify the number to round. You can pass any numeric data (or cell reference containing numeric data).
Note: The result may be rounded up or rounded down.
Use the places parameter to specify the number of decimal places. The places argument has these rules:
- Set places to a value >0 to round to the specified number of decimal places.
- Set places to zero to round to the nearest whole number.
- Set places to a value <0 to round the value left of the decimal to the nearest ten, hundred, etc.
ROUND(A3,-2)
ROUND(C4,B2)
ROUND(PI(),5) //3.14159
ROUND(29.2,-2) //0 because 29.2 is closer to 0 than to 100.
ROUND(-1.963,0) //-2
PROPERTIES
Product: 4D
Theme: 4D View Pro Formulas
PAGE CONTENTS
HISTORY
ARTICLE USAGE
4D View Pro Reference ( 4D v19)
© 1985-2025 4D SAS / 4D, Inc. All rights reserved.