> For the complete documentation index, see [llms.txt](https://docs.tomat.ai/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.tomat.ai/data-transformation/formulas/aggregate-functions/medianif.md).

# MedianIf

Gets the median value in the column filtered by the condition

```mathematica
MedianIf(column1, column2 == "20") → 30
MedianIf(column1, column1 > Round(column2)) → 6
```

#### Inputs

`MedianIf(column, [condition])`

* `column` - A column to calculate the median value for
* `[condition]` - **\[optional]** - Condition to filter values in the column