4D v17
MAX
- 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
- SIN
- SQRT
- STDEV.P
- SUBSTITUTE
- SUM
- TAN
- TEXT
- TODAY
- TRUE
- TYPE
- VAR.P
4D v17
MAX
MAX
| MAX ( value {, value2 , ... , valueN} ) | ||||||||
| Parameter | Typ | Beschreibung | ||||||
| value | Zahl, Array |
|
Number or numeric array to evaluate | |||||
The MAX function returns the greatest (maximum) value of value. It accepts and returns numeric data.
In value, pass the values to evaluate. Each argument can be a number or an array of numbers. You can use a single array (cell range) or multiple arrays (cell ranges).
If an array or reference contains text, logical values, or empty cells, MAX ignores those values; however, cells with the value zero are included in calculations.
MAX(A1,B2,C3,D4,E5)
MAX(A1:A9)
MAX(2,15,12,3,7,19,4) //19
Siehe auch
EIGENSCHAFTEN
Produkt: 4D
Thema: Formeln in 4D View Pro
GESCHICHTE
ARTIKELVERWENDUNG
4D View Pro Handbuch ( 4D v17)
© 1985-2020 4D SAS / 4D, Inc. Alle Rechte vorbehalten.