=NOT(logical)

Unlike AND and OR, the ONLYOFFICE NOT reference documents one logical argument, with no optional additional conditions. If you want to invert several tests, combine them first with AND or OR, then wrap that entire expression in NOT(...).

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:

=NOT(D2="Ready")

Expected G2: FALSE because A101 is ready. Copy down through G6:

The two flagged orders are A102 and A104. This check means anything other than exactly Ready, so a truly empty status cell could also merit attention; a negative condition is not the same as explicitly identifying Pending or Hold.

In a spare result column, enter:

=IF(AND(NOT(D2="Ready"),B2>=100),"Escalate","No action")

Fill through row 6. Expected row results: No action, No action, No action, Escalate, No action. Row 3 is non-ready but has spend 80, below the escalation threshold; row 5 is on hold and has spend 160, so both required conditions are TRUE. IF’s true/false label order is verified against ONLYOFFICE IF help.

For a more compact alternative to an existing exception test, use:

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

Expected results for rows 2–6: TRUE, FALSE, TRUE, FALSE, TRUE. This describes orders for which neither a Hold status nor a zero-unit issue exists. It is logically equivalent, on this fully specified sample, to =AND(D2<>"Hold",C2<>0); do not assume those expressions behave identically if a cell contains an error or unexpected type until you test the target build.

• NOT(D2="Ready") flags Pending, Hold, and any other nonmatching entry. If you wanted only Hold, write D2="Hold" instead.
• NOT(B2>=100) represents B2<100 for the clean numeric values shown. Be careful when generalizing that equivalence to mixed-type or error-containing cells without native confirmation.
• NOT accepts one logical expression, not a comma-delimited list of unrelated conditions. Compose NOT(OR(...)) or NOT(AND(...)) as intended.
• =NOT(TRUE) is expected FALSE, and =NOT(FALSE) expected TRUE according to the official inverse rule; these literal examples isolate logical behaviour from cell-format issues.
• A formula text value such as "FALSE" is not the same as a Boolean FALSE. The vendor’s NOT page does not detail conversions for every text/numeric input; avoid unsourced coercion rules.

The official Microsoft Excel NOT guide confirms the same NOT(logical) signature and inversion truth table. Both products document combining NOT with IF, AND and OR; that common core is portable in principle. However, neither the vendor documentation comparison nor this batch proves parity in how mixed-type cells, array references or errors are evaluated by particular releases. Check the target product and locale before importing complex workbooks.

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 help

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.