# Documentation/Calc Functions/MODE

From The Document Foundation Wiki

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## Function name:

MODE

## Category:

Statistical Analysis

## Summary:

Finds the most common value in a data set. If there are several values with the same frequency, it returns the smallest value. An error occurs when no value appears more than once.

## Syntax:

MODE(**Number 1** [; **Number 2** [; … [; **Number 255**]]])

## Returns:

Returns a real number which is the most common value in the list of arguments.

## Arguments:

**Number 1**, **Number 2**, … , **Number 255** are numbers, references to cells or to cell ranges of numbers.

- If any of the arguments contain text value being passed directly then the function returns a name(#NAME?) error and if with double quotes a simple error value(Err:504) is returned.
- If a cell contains text, error value, or empty cells, then the function ignores these values. However, for logical values, TRUE is considered as 1 and FALSE as 0.
- If a cell has 0 then the function includes it.

## Additional details:

None

## Examples:

Formula | Description | Returns |
---|---|---|

=MODE(A1:A10) where A1:A10 contains 1,2,3,2,4,1,3,5,6,3 | The function returns the most common value amongst the passed arguments | 3 |

=MODE(1,2,3,2,4,1,3) | The function returns the most common value amongst the passed arguments. Here since there are three values with the highest frequency so the function returns the smaller value. | 1 |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

MODE