Category - Statistical
List of user defined functions
| AVERAGETOP | *Returns the average from a range of values only considering the top "x" values. |
| AVERAGEVISIBLE | Returns the average value from visible, non blank cells. |
| AVERAGEVISIBLEA | *Returns the average value from visible, non blank cells in a range (including logical values and text). |
| AVERAGEVISIBLEIFS | Returns the average value from visible, non blank cells that satisfies multiple condition. |
| MAXBETWEEN | *Returns the largest value that is between a range. |
| MAXVISIBLE | Returns the largest value from visible, non blank cells in a range. |
| MAXVISIBLEA | *Returns the largest value from visible, non blank cells in a range (including logical values and text). |
| MAXVISIBLEIFS | Returns the largest value from visible, non blank cells that satisfies multiple condition. |
| MEDIANIFS | *Returns the middle value in a range of values that satisfies multiple conditions. |
| MEDIANVISIBLE | *Returns the middle value from visible, non blank cells in a range. |
| MEDIANVISIBLEIFS | *Returns the middle value from visible, non blank cells that satisfies multiple conditions. |
| MINBETWEEN | *Returns the smallest value that is between a range. |
| MINVISIBLE | Returns the smallest value from visible, non blank cells in a range. |
| MINVISIBLEA | *Returns the smallest value from visible, non blank cells in a range (including logical values and text). |
| MINVISIBLEIFS | Returns the smallest value from visible, non blank cells that satisfies multiple condition. |
| PRODUCTVISIBLE | *Returns the product of visible non blank cells. |
| AVERAGETOP *Returns the average from a range of values only considering the top "x" values. |
| AVERAGEVISIBLE Returns the average value from visible, non blank cells. |
| AVERAGEVISIBLEA *Returns the average value from visible, non blank cells in a range (including logical values and text). |
| AVERAGEVISIBLEIFS Returns the average value from visible, non blank cells that satisfies multiple condition. |
| MAXBETWEEN *Returns the largest value that is between a range. |
| MAXVISIBLE Returns the largest value from visible, non blank cells in a range. |
| MAXVISIBLEA *Returns the largest value from visible, non blank cells in a range (including logical values and text). |
| MAXVISIBLEIFS Returns the largest value from visible, non blank cells that satisfies multiple condition. |
| MEDIANIFS *Returns the middle value in a range of values that satisfies multiple conditions. |
| MEDIANVISIBLE *Returns the middle value from visible, non blank cells in a range. |
| MEDIANVISIBLEIFS *Returns the middle value from visible, non blank cells that satisfies multiple conditions. |
| MINBETWEEN *Returns the smallest value that is between a range. |
| MINVISIBLE Returns the smallest value from visible, non blank cells in a range. |
| MINVISIBLEA *Returns the smallest value from visible, non blank cells in a range (including logical values and text). |
| MINVISIBLEIFS Returns the smallest value from visible, non blank cells that satisfies multiple condition. |
| PRODUCTVISIBLE *Returns the product of visible non blank cells. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited TopPrevNext