# MAX

#### Syntax <a href="#syntax.29" id="syntax.29"></a>

**MAX**(*range*; *orientation*)

* *range* - a range of values - Value type: range
* *orientation* - the orientation of the maximum calculation - Value type: constant (optional, *<mark style="color:red;">all</mark>* as default). Possible values are:
  * *<mark style="color:red;">all</mark>* - the maximum of the whole range is returned as a single number
  * *<mark style="color:red;">horizontal</mark>* - the maximum calculation is performed horizontally (row-wise) and returned as a column of numbers“
  * *<mark style="color:red;">vertical</mark>* - the maximum calculation is performed vertically (column-wise) and returned as a row of numbers

#### Remarks <a href="#remarks.24" id="remarks.24"></a>

* Empty cells or cells which cannot be converted to numbers are ignored in the maximum calculation.

#### Examples

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-4e377b611e7a9c11fb236e7e30634b5c2ba456fc%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-b3ced89c492c2132c747bd44ac97e70527293287%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://1085786630-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FWv5M2BoEVu0kDIV5EPs4%2Fuploads%2Fgit-blob-a813c3979daf912bcd70975f15d7bb2a169cabe1%2Fgrafik.png?alt=media" alt=""><figcaption></figcaption></figure>