As with SUM, it only applies to cells that are formatted as numeric values (including dates, percentages etc. as well as your bog-standard numbers). But if you try to do a minimum across a range that includes some cells containing non-numeric values, it will still work. It will simply ignore those cells in performing its calculation.
If the cells in your range contain the values 1, 2, 3, Y and 4, then the function will return the value 1, the minimum of 1, 2, 3 and 4. The Y will be ignored. Blank cells will be similarly ignored. Similarly, the formula will ignore logical values (i.e. those that contain a TRUE/FALSE value). But cells containing a zero will count towards the calculation. So if the cells in your range contain the values 1, 2, 3, 0, 4, the formula will return the value 0.
This entry was posted in Formulae explained and tagged MIN. Bookmark the permalink.