IFS in Collabora Office: Return the First Matching Condition Result
Use Collabora IFS with ordered conditions, a deliberate fallback and reproducible threshold tests.
Verification status: See the evidence and test scope described in this guide. How formula examples are checked
Quick answer: =IFS(75>=90;"High";75>=70;"Middle";TRUE();"Low") has independently expected result “Middle”. IFS returns the result belonging to the first true condition.
Syntax and ordered pairs
=IFS(expression1; result1 [; expression2; result2 ...])
Each expression is a Boolean condition and must have a corresponding result. The dedicated Collabora help documents up to 127 condition/result pairs. The order is significant: once a matching condition is selected, later matches do not replace its result.
The documentation describes the logical selection as nested IF conditions. That does not by itself certify whether every unused result expression is evaluated internally. This guide uses safe literal results and does not depend on an unverified error-suppression or lazy-evaluation promise.
Unlike an ordinary IF with a final else argument, IFS has no separate bare default slot. To provide a fallback, add a final TRUE() condition followed by its result.
Example 1: classify scores using descending thresholds
Put 59, 70, 75, 89, 90 and 100 in A2:A7. Enter =IFS(A2>=90;"High";A2>=70;"Middle";TRUE();"Low") in B2 and fill down.
Independent targets are Low, Middle, Middle, Middle, High and High. These are illustrative reporting bands, not an assessment or eligibility policy. The row exactly at 70 is included in Middle; the row exactly at 90 is included in High.
The highest threshold appears first. If A2>=70 were tested before A2>=90, a value of 100 would match the earlier Middle condition and never select the intended High result.
Example 2: make overlapping conditions visible
For A2=95, both A2>=90 and A2>=70 are TRUE. The first formula above returns High because its conditions are ordered from most specific to broader.
Compare =IFS(95>=70;"Middle";95>=90;"High";TRUE();"Low"). Its independent result is Middle. The formula is syntactically valid but expresses a different priority rule.
Keep a small boundary table with one value below, equal to and above each threshold. Testing only a middle-of-band value can miss incorrect ordering and inclusive-versus-strict comparisons.
Advanced application: use independent conditions, not only bands
Suppose A2 contains an illustrative item count and B2 a Boolean hold flag. Use =IFS(B2;"On hold";A2=0;"Empty";TRUE();"Available").
For rows (0;TRUE), (0;FALSE), (5;FALSE) the independent labels are On hold, Empty and Available. The hold condition has priority even when the count is zero. Swapping those two tests changes the result for the first row.
This makes precedence explicit without nesting several IF calls. It does not validate whether the count or flag was imported correctly; input validation remains a separate concern.
Advanced application: return numbers for later arithmetic
For the score table, =IFS(A2>=90;3;A2>=70;2;TRUE();1) gives independent numeric codes 1, 2, 2, 2, 3 and 3. These can be used in arithmetic without parsing the display labels.
Do not mix a numeric result in one branch with numeric-looking text in another unless that type difference is intentional. A visible 3 and the text “3” can behave differently downstream even though a narrow column makes them look similar.
Errors and troubleshooting
The cited help documents #N/A when no expression is true or an expression lacks its corresponding result. It documents #VALUE for an expression that is neither TRUE nor FALSE. Those are documentation statements, not newly captured native error cells.
A trailing default text without its TRUE condition is not the documented fallback structure. Place the fallback last, because an always-true condition earlier would take priority over every later branch.
IFS chooses one result. It does not return every matching label or combine multiple independent outcomes. Check data types, condition order and boundary operators before adding more pairs to a formula that already expresses the wrong rule.
Availability and verification
The exact function is documented in Collabora Office 26.04 desktop help. This function’s cited help snapshot was retrieved on 2026-10-15 and hash-verified on October 15, 2026. Desktop documentation does not establish Online or mobile support. First introduction and last functioning release are unknown in this evidence.
No native Collabora Office execution occurred. Worked results are independent logical, calendar, structural or mathematical expectations. Formulas use English names and semicolon argument separators.
The help identifies namespace COM.MICROSOFT.IFS, outside its cited OpenFormula 1.3 standard. That format disclosure does not guarantee identical behavior in other software.