AND Function in ONLYOFFICE Spreadsheet Editor: Syntax and Worked Examples

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

The square brackets mean that a later argument is optional; never type them into a formula. The ONLYOFFICE AND page demonstrates conditions such as A1<100 and confirms the all-true rule. It does not state an AND-specific maximum number of arguments; do not import a limit from a different product without checking your build. For text criteria, make explicit comparisons such as D2="Ready" rather than passing a text cell and assuming a truth value.

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.

In G2 enter:

=AND(B2>=100,C2>0)

Expected G2 result: TRUE, because A101 has spend 150 >= 100 and units 3 > 0. Fill through G6:

How to check without a function: calculate each comparison independently. Only the conjunction of two TRUE results qualifies; the nonqualifying order is row 3. These truth values are deterministic comparisons of the typed sample data, not runtime observations.

In a spare column such as H2:

=IF(AND(B2>=100,C2>=2,D2="Ready"),"Priority","Standard")

Fill through H6. Expected values: row 2 Priority, row 3 Standard, row 4 Priority, row 5 Standard, row 6 Standard. Row 5 has enough spend and units but is Hold rather than Ready. Row 6 is Ready but has only one unit. This is why changing AND to OR would implement a different business rule, not simply a shorter formula. The argument order and conditional labels for the nested IF are corroborated by the ONLYOFFICE IF reference.

For an inclusive spend band, enter =AND(B2>=100,B2<=200) in another free column. The independently expected results for rows 2–6 are TRUE, FALSE, FALSE, TRUE, TRUE. Both bounds must hold; 220 fails the upper bound even though it exceeds 100.

• AND(B2>=100,C2>0) expresses intersection, not addition and not counting matching records. For how many qualifying rows exist, use a suitable multi-criteria counting approach such as the site’s COUNTIFS guide.
• =AND(TRUE,FALSE) has the expected result FALSE; =AND(TRUE,TRUE) has the expected result TRUE according to the all-true rule. When diagnosing an input issue, begin with comparisons that are known Boolean, not a whole-column reference containing unrelated text.
• A blank status or an imported numeric-looking string requires explicit data validation; the official AND page does not document every cell-type conversion or failure mode. Avoid asserting that it treats text references exactly as Microsoft Excel.
• An error inside a logical test is not a substitute for FALSE. This guide does not claim a particular error propagation/short-circuit evaluation order without a real editor test.

The Microsoft Excel AND documentation uses the same AND(logical1,[logical2],...) pattern and the same all-true truth rule. Excel explicitly documents a 255-condition maximum and how referenced blank/text cells are treated; the current ONLYOFFICE page does not provide the same implementation detail. This is an evidence gap, not proof that the engines differ. Comma examples are suitable for the English documentation; local installation separators may differ in either product. Do not claim byte-for-byte compatibility of imported sheets or array formulas without testing the intended editor build.

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 reference

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.