Dies ist die alte 4D Dokumentations-Website. Die neue und aktualisierte Dokumentation finden Sie unter developer.4d.com
- 4D View Pro Handbuch
-
- Formeln in 4D View Pro
-
-
Operatoren und Werte
-
Zellenreferenzen
-
Formeln vom Plug-In 4D View konvertieren
-
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 | Typ | Beschreibung | ||||||
| value | Zahl |
|
Number to round | |||||
| places | Zahl |
|
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
EIGENSCHAFTEN
Produkt: 4D
Thema: Formeln in 4D View Pro
SEITENINHALT
GESCHICHTE
ARTIKELVERWENDUNG
4D View Pro Handbuch ( 4D v19)
© 1985-2025 4D SAS / 4D, Inc. Alle Rechte vorbehalten.