MAX

This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com

Home

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

Home

4D v19

4D View Pro Reference

4D View Pro Formulas

MAX


MAX ( value {, value2 , ... , valueN} )

Parameter	Type	Description
value	Real, Array	Number or numeric array to evaluate

Description

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.

Example

MAX(A1,B2,C3,D4,E5)

MAX(A1:A9)

MAX(2,15,12,3,7,19,4) //19