OR Function in ONLYOFFICE Spreadsheet Editor: Syntax and Worked Examples

=OR(logical1, [logical2], ...)

The official ONLYOFFICE OR help explicitly documents up to 255 logical values and explains the any-true rule. The optional-argument notation [logical2] is explanatory syntax, not characters entered in a cell. Multiple condition expressions must be separated using the notation accepted by your installation; the current English guide uses commas.

This function is listed in ONLYOFFICE’s current unversioned web help under logical functions. The official reference confirms the syntax described below, but does not identify the first version of Docs, Desktop Editors, or the mobile apps that implemented this function. The separate Docs release history and Desktop Editors release history are version-scoped records; their absence of a function introduction is not evidence that every old build supports it. No web-versus-desktop equivalence has been tested here. If you use an older build, search for this function in its Formula > Function dialog and run the sample before relying on it.

These formulas follow ONLYOFFICE’s English documentation and use comma-delimited arguments. Start with =, put text comparisons in double quotes, and do not type square brackets from the syntax notation. The official insertion guide says to separate arguments with commas and describes the Formula tab, function wizard and Shift+F3 shortcut. Interface language or locale may affect displayed formula names or separators; the exact behaviour for a non-English installation was not tested, so follow the separator in that installation’s own function wizard rather than assuming the examples paste unchanged.

Create an empty worksheet, type the headers in A1:E1, and enter the numeric spend and units as numbers, not as strings. Use exactly this table for the examples below:

Enter the example formula into an empty result cell such as G2, press Enter, and, where instructed, copy/fill downward through G6. If your sheet already has data, use another clean area so that references still point to the intended fields. The outputs shown are independently derived expectations, not screenshots or native ONLYOFFICE execution results.

Enter in G2:

=OR(D2="Hold",C2=0)

Expected G2 result: FALSE. The first order is Ready and has 3 units, so neither reason applies. Fill the formula through G6:

The review group consists of orders A102 and A104. A102 triggers only the zero-unit rule, while A104 triggers only the Hold rule. The calculation is reproducible by checking each input row against those two explicit conditions.

To turn the Boolean result into a label, enter in H2:

=IF(OR(D2="Hold",C2=0),"Review","Proceed")

Fill through H6. Expected labels: Proceed, Review, Proceed, Review, Proceed. The ONLYOFFICE IF page confirms the order logical_test, value_if_true, value_if_false. An exception rule should return Review when either exception is present; using AND here would incorrectly require both problems at once.

For a different policy—spend at least 100 and an allowed channel—enter:

=AND(B2>=100,OR(E2="Web",E2="Store"))

Expected rows 2–6: TRUE, FALSE, TRUE, TRUE, TRUE. The nested OR represents a set of acceptable channels; the outer AND applies the mandatory spend threshold. If a third channel appears later, add an explicit third E2="..." test to the nested OR.

• OR is inclusive: if two tests are TRUE, it still returns TRUE. It is not an exclusive-OR test. ONLYOFFICE separately documents XOR, but its multi-value behaviour should be reviewed before replacing a policy formula.
• =OR(FALSE,FALSE) is expected FALSE, and =OR(FALSE,TRUE) expected TRUE under the official truth rule; use these simple checks when diagnosing an input-range problem.
• An OR expression using B2>=100 and B2<=200 would be true for nearly every ordinary numeric B2; for a bounded range you need AND, not OR.
• The reference does not provide complete rules for ignoring text or blanks inside a referenced array. Use comparisons with known types for reliable teaching examples, and validate imported data before extending a formula to large ranges.
• OR is a Boolean test, not a row counter. Use COUNTIF/COUNTIFS for counts and IF for labels; choose the function according to the output you actually need.

Excel’s OR guide independently confirms the same any-true logic, optional later arguments, and 255-argument limit. Excel’s remarks also discuss the treatment of blanks and text within range arguments, which the linked ONLYOFFICE reference does not specify. That is an unverified compatibility area, not proof of a difference. Expect the English formulas to look familiar in Excel, but do not assume localized delimiters, array treatment, or error propagation are identical on a particular desktop or web release.

1. If you see an unexpected TRUE/FALSE or label, verify every row of the supplied sample table and the exact comparison operator (>= is not >). Confirm that copied formulas are still pointing at the intended columns.
2. If you see an error, first simplify the expression to its individual comparisons, for example =B2>=100 and =C2>0. Reinsert the function through ONLYOFFICE’s Function Arguments dialog to rule out spelling, punctuation or separator mistakes. Error codes arising from particular malformed inputs are not established by these documentation-only examples.
3. Check whether numeric values were imported as text, whether status text contains extra spaces, and whether an empty cell has been confused with an explicit zero. Avoid guessing how referenced arrays handle text or blanks; use explicit comparisons on known typed values and test the target editor.
4. Turn on Show Formulas in the Formula tab to inspect the entered expression. The official help also documents workbook recalculation through the Formula tab or F9 if source data changes are not reflected.

• COUNTIF in ONLYOFFICE
• SUMIF in ONLYOFFICE

• ONLYOFFICE Spreadsheet Editor — function documentation
• Docs release history
• Desktop Editors release history
• official insertion guide
• ONLYOFFICE IF page

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

• No genuine ONLYOFFICE Spreadsheet Editor screenshots are included; this guide does not use mock application images.