Browse

IFS in Zoho Sheet: Grade amounts with ordered conditions

Logical Intermediate Zoho Sheet

Use Zoho Sheet IFS to classify payment amounts into bands, test threshold order and provide a fallback.

Verification status: Official documentation referenced; example outcomes independently reasoned or arithmetically checked where stated. Not executed in Zoho Sheet. How formula examples are checked

Quick answer: A store may need one of three review classes rather than a simple yes/no. IFS expresses a tiered policy without a long stack of nested IF calls.

This is a Zoho Sheet-specific tutorial, written against Zoho’s official online function reference checked on October 10, 2026. The vendor help does not identify a minimum Zoho application release for this function; a historical introduction date has not been verified. No example in this guide was run in a signed-in Zoho Sheet account. Expected outputs are independently checked against the supplied sample data.

Syntax and parameters

=IFS(test; value; [test2]; [value2]; ...)
Parameter Meaning
test First logical condition. Zoho evaluates cases in their supplied order.
value Returned when its paired condition is the first true test.
additional pairs Optional further condition/result pairs in sequence.

Reproduce the example with real data

Download the eight-row CSV dataset and import it into a blank Zoho Sheet starting at cell A1; this creates a header on row 1 and data in rows 2–9. Leave the output area outside A1:F9. If IDs or numbers were changed during import, correct their data types before continuing.

These are representative records from the downloadable dataset (the formula ranges reference all eight records):

Row A: Order ID B: Region C: Status D: Amount E: Agent F: Units
2 O-101 East Paid 120 Ana 12
3 O-102 West Pending 75 Bo 5
4 O-103 East Paid 210 Ana 7
5 O-104 North Paid 90 Cy 0

Enter the formula in a vacant cell, for example H2:

=IFS(D4>=200;"High";D4>=100;"Medium";TRUE;"Low")

Expected result: High.

Walkthrough: O-103 is worth 210. The first condition (at least 200) is true, so later checks do not replace High.

A second example

=IFS(D3>=200;"High";D3>=100;"Medium";TRUE;"Low")

Expected result: Low. The 75 amount satisfies neither threshold; the final TRUE case supplies the catch-all classification.

More advanced use

=IFS(D2>=200;"High";D2>=100;"Medium";TRUE;"Low")

Expected result: Medium. O-101 is worth 120. It misses the first band and meets the second, giving Medium.

To make classification policies auditable, keep threshold definitions in visible cells and document whether comparisons include equality. When someone changes tiers next month, this is safer than silently editing every row’s formula.

Common errors and troubleshooting

  • Put the most restrictive overlapping threshold first. Reversing the 100 and 200 tests would classify 210 as Medium.
  • Include a final TRUE;"Low" pair if every valid amount needs a label. Without a matching condition the formula can yield a no-match error.
  • Every test needs a corresponding output; missing pairs can make syntax invalid.
  • Clean numeric-looking text such as $210 imported from another source before testing numeric comparisons.

Compatibility and version notes

IFS is also available in modern Excel and LibreOffice, but availability can vary across older versions. Zoho documentation does not give a minimum Zoho build number, so this guide makes no invented version claim.

The examples deliberately follow Zoho’s semicolon-separated syntax. Spreadsheet software may use different argument separators based on product and locale. This guide covers the current documented Zoho function, not an unverified assertion about support in older releases.

Official reference and verification

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.