DELTA in Google Sheets: Compare Numbers and Check the Blank-Cell Trap

• Introduced: first introduction date is not established by the reviewed official history; no desktop release number is inferred.
• Availability: documented in the rolling Google Sheets service; these examples use the web worksheet workflow.
• Checked: October 14, 2026; official DELTA reference. Documentation and independent models, with no native Sheets execution or wider client certification.

=DELTA(number1,[number2])

The first number is required. The second defaults to zero. Google’s dedicated page documents the equality result 1, numeric-only comparisons and the blank-as-zero rule; it directs comparisons of other value types to EQ, equivalent to the equals operator.

The short reference does not explicitly state the unequal-case output or give an error-code matrix. This guide does not promote the familiar mathematical zero-on-inequality model into a native-tested Sheets claim. Where a complete 1/0 report is needed below, an explicit IF comparison supplies both branches.

That source limit does not prevent useful equality controls. It does mean that a report should make its required nonmatch behavior explicit rather than hide it behind an unverified edge assumption.

Enter these numeric pairs in A2:B5 and put =DELTA(A2,B2) in C2, filling through C5.

The fractional control uses one quarter, which has an exact finite binary representation. It avoids using a rounded display as evidence that two internally calculated decimal quantities are identical.

Change the first value in A2 to 8. That creates a deliberate unequal pair. The expression =A2=B2 now returns FALSE, and =IF(A2=B2,1,0) returns zero. These are explicit alternative comparison controls; the guide leaves the raw unequal DELTA output unclassified by its reviewed source.

Clear D2 so that it is physically empty, and enter numeric zero in D3. The following are documented equality controls:

All four match because the blank cell is treated as zero. DELTA alone therefore cannot tell an actual recorded zero apart from a missing numeric entry.

To distinguish those two cases, inspect =ISBLANK(D2) and =ISBLANK(D3), which give TRUE and FALSE for this fixture. ISBLANK checks physical emptiness in these examples; this is not a claim that every formula producing an empty-looking result has the same classification.

For a numeric-only validation workflow, =ISNUMBER(D2) is FALSE and =ISNUMBER(D3) is TRUE. ISNUMBER checks type rather than whether a quantity is acceptable for your business rule.

Enter planned quantities 8, 5, 0 and −2 in F2:F5, and recorded quantities 8, 6, 0 and −2 in G2:G5. In H2 enter and fill down:

=IF(F2=G2,1,0)

Expected flags are 1, 0, 1 and 1. =SUM(H2:H5) returns three matches, and =SUM(H2:H5)/4 returns 0.75, displayed as 75% when formatted as Percent.

To retain a DELTA check on the matched rows while explicitly setting nonmatches to zero, use =IF(F2=G2,DELTA(F2,G2),0). The expected flags are the same. This formula does not require a general claim about shortcut evaluation or the raw unequal DELTA return value; its selected match branch uses equal numeric inputs.

Keep a separate missing-input check before treating zero quantities as valid records. The four records above are all explicit numbers, so the blank-cell ambiguity does not affect their match count.

Put row labels 1, 2 and 3 in J2:J4 and column labels 1, 2 and 3 in K1:M1. Enter this in K2 and fill across and down through M4:

=IF($J2=K$1,DELTA($J2,K$1),0)

Expected rows are 1,0,0; 0,1,0; and 0,0,1. Each row and column sums to one, and the diagonal sums to three. The explicit zero branch controls nonmatching labels, while DELTA verifies the matching numeric pairs.

Numeric 12.25 and 12.5 are different even if a coarse cell format makes their displays less informative. If a tolerance of 0.25 is intended, state that separate rule with =ABS(12.25-12.5)<=0.25, giving TRUE. Exact equality and acceptable difference answer different questions.

The source does not certify numeric-text coercion, Boolean inputs, formula-generated empty values or specific invalid-type errors. Use actual numeric inputs for these controls and an explicit equals comparison for other documented value comparisons. No native Sheets execution was performed.

• Google DELTA reference.
• Editorial testing standards.

Examples use fictional data, English function names and comma separators. Expected outputs are independent mathematical calculations or explicitly documented rules, not native Sheets captures. Check the spreadsheet locale when reproducing punctuation-sensitive formulas.