# MIN

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

**MIN**(*range*; *orientation*)

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

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

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

#### Examples

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-cb1c2ca384a90c63d974e0e542a609a1b1676ff4%2Fgrafik%20(298).png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-69f3248df44744bd2fff15e39ffb1339b23f56ff%2Fgrafik%20(453).png?alt=media" alt=""><figcaption></figcaption></figure>

<figure><img src="https://3148043601-files.gitbook.io/~/files/v0/b/gitbook-x-prod.appspot.com/o/spaces%2FL43fiRbeRtPnTjMpbGNO%2Fuploads%2Fgit-blob-9b8566171672cef2acc0fc2961507be9c9a96773%2Fgrafik%20(382).png?alt=media" alt=""><figcaption></figcaption></figure>