MIN in Zoho Sheet: Syntax, Worked Examples, and Troubleshooting

=MIN(number; [number1]; ...)

Zoho’s official reference uses the expression above. Brackets indicate optional arguments, not text to type. All formula examples use Zoho’s English help syntax with semicolon argument separators. Numeric displays may gain currency symbols or decimal places depending on cell formatting. Read the answer as a number unless the guide expressly says it is text. The formulas below use cell references relative to the stated table.

Prepare this eight-order practice data

1. Open a blank Zoho Sheet and paste the table below into cells A1:F9, using row 1 for its six headers. A CSV with these exact eight records is also included in this batch; import it at A1 if copying the table is inconvenient.
2. Check that cells in the Amount and Units columns are numeric, not text imported from a CSV. Keep the headers out of formula ranges unless the guide explicitly says otherwise.
3. Enter the formula in an unused result cell such as H2, away from the original records; do not place it inside its input range.
4. Check the expected output against the values in the table before substituting your business data. These expected outputs are independently calculated, not verified by running Zoho Sheet.

Main calculation

=MIN(D2:D9)

Expected result: 60. The smallest Amount belongs to order O-106 in row 7; its value is 60.

Check the cell range character by character. If your result is different, confirm the row numbers, number formatting and that your inputs match the sample before changing the formula. The numbers here are calculated independently from the table, not copied from an application screenshot.

Second practical example

=MIN(F2:F9)

Expected result: 0. Order O-104 has zero units in F5; MIN includes that genuine numeric zero.

This is a second, separately reasoned test case using the same named inputs. When working with another workbook, change the column references deliberately and keep comparison criteria or array dimensions aligned.

=IF(MIN(F2:F9)=0;"Investigate zero-unit orders";"All unit counts positive")

Expected result: Investigate zero-unit orders. Pair MIN with IF to create a quality flag. Because F5 is zero, the condition evaluates true. This is a convenient prompt to verify whether zero-unit orders are placeholders or data issues.

For formula composition, first confirm the simpler formula works, and only then add nested functions or criteria. The advanced formula must be entered in a different unused cell, e.g. H4, to keep it away from the source ranges.

MIN ignores text entries but the vendor reference specifies that a range containing no numbers returns 0. Do not assume an all-text column with MIN = 0 means a genuine zero-valued observation. If negative quantities are present, MIN returns the most negative value rather than the smallest absolute magnitude. If all you need is the first low record, MIN returns the number, not the corresponding Order ID; use INDEX/XMATCH with care for ties.

Typical formula failures to investigate: #NAME! can indicate a misspelled function or undefined name; #REF! suggests a broken range reference; #VALUE! can indicate a wrong argument type. These are documented as possible errors in Zoho’s function help, but the precise error for a specific imported cell was not native-tested here. Check the formula bar, source cell data types, and range sizes before deciding that the function is broken.

If a formula returns an unexpected blank or zero, compare the relevant input rows with the worked sample. Check mixed numeric/text imports, copy-pasted quotes, leading/trailing spaces, and whether the selected input cells were moved or renamed. Do not infer an application version limitation solely from one failed formula: confirm function availability and syntax in Zoho’s in-app formula assistant.

MIN exists across spreadsheet products. Zoho’s documented no-numbers fallback is 0; for other products, confirm how text values, booleans and empty ranges are treated before migrating data-quality rules.

Cross-software transfer: Excel, Google Sheets, and LibreOffice Calc also use the named function for ordinary numerical cases, but do not copy argument separators blindly: Zoho’s English help examples use semicolons (;). Syntax details, empty-cell behavior, handling of text and errors, and compatibility with exports can differ. Test a small verified dataset after migrating rather than assuming a Zoho formula will behave exactly like an Excel or Numbers one.

• MAX guide
• COUNT guide
• AVERAGE guide
• INDEX guide
• XMATCH guide

• Zoho Sheet — function documentation
• Zoho Sheet — official function category
• Zoho Sheet — full function index

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Zoho Sheet.

• No genuine Zoho Sheet screenshots are included; this guide does not use mock application images.