MINA Function

Returns the smallest value, counting text as 0 and TRUE as 1.

Category

Statistical

Available in

All versions, Microsoft 365

Returns

A number

Want to practice MINA in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

MINA works like MIN, but in a range it also counts text (as 0), TRUE (as 1) and FALSE (as 0). Empty cells are still skipped.

Useful when a text entry such as "offline" should count as zero.

Syntax

=MINA(value1, [value2], …)

Arguments

ArgumentRequired?What it does
value1YesA value, cell or range.
value2, …NoUp to 255 more values, cells or ranges.

Examples

Example 1 — Lowest reading, counting outages

A warehouse sensor logs "offline" when it stops reporting.

D2fx=MINA(B2:B5)
ABCD
1HourReadingMINA
209:004.50
310:003.8MIN
411:00offline3.8
512:005.2
=MINA(B2:B5) Explain

Common mistakes

  • Text becomes the minimum. With positive numbers, any text in the range makes MINA return 0. Use MIN to ignore text.

Notes

Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.