EXACT Function in Apple Numbers: Syntax, Examples and Troubleshooting

EXACT returns the Boolean value TRUE when two text strings have identical characters in identical case, and FALSE otherwise. It is useful for spotting mismatched IDs, case differences and unexpected spaces. Unlike a visual comparison, it does not silently treat Acme and ACME as equal.

Compare two pieces of text with case-sensitive, character-for-character matching. First check whether the input needs to be treated as text so that leading zeroes, spaces or punctuation are not silently changed during import. Start with the sample table below, verify its result, and only then adapt your formula to production records.

=EXACT(string-1, string-2)

The syntax and parameter order above are taken from Apple’s EXACT reference (consulted 2026-10-11). Arguments shown as … are optional extra values, not punctuation to type literally. No first-supported Numbers app version was established by the official reference.

Create a Numbers table named Text Checks. Enter the following text data exactly, including the leading spaces in row 6. The two quoted strings in row 6 are not literally quoted in the cells.

1. In C2 of the same table, type =EXACT(A2,B2).
2. Confirm the expected logical result is TRUE, because ACME has identical capitalization and characters in A2 and B2.
3. Copy the formula from C2 through C6. Relative references follow the rows.
4. Expected C2:C6: TRUE, FALSE, TRUE, FALSE, FALSE. Rows 3 and 5 differ by capitalization and punctuation/spacing, respectively; row 6 contains extra leading spaces.

A direct literal check is =EXACT("Case","case") → expected FALSE, whereas =EXACT("Case","Case") → expected TRUE.

Audit imported reference IDs without losing leading zeroes

In a separate table, store identifiers as text. If A2 is INV-001 and B2 is INV-001, =IF(EXACT(A2,B2),"Approved","Review") is expected to show Approved. If B2 is INV-01, the same formula yields Review. The IF function supplies a readable status; EXACT supplies the case-sensitive comparison.

To avoid approving empty pairs, use =IF(AND(LEN(A2)>0,EXACT(A2,B2)),"Approved","Review"). With empty A2 and B2, the result is Review (independent logical evaluation). AND and LEN are separately documented Numbers functions; see the function directory for their current availability.

• Hidden spacing: trailing spaces, leading spaces, and embedded spaces can produce FALSE. Try LEN(A2) and LEN(B2) to compare lengths; if trimming is appropriate, use EXACT(TRIM(A2),TRIM(B2)), but do not normalize when exact spacing is meaningful.
• Case sensitivity: EXACT("item","ITEM") is FALSE. Use a deliberate normalization such as EXACT(UPPER(A2),UPPER(B2)) only when case should be ignored. This changes the comparison policy.
• Text versus number: IDs such as 0012 can lose leading zeros if pasted as numbers. Set appropriate text formatting before import and confirm the displayed input data. Apple’s EXACT documentation specifies string values; do not infer all number coercions from these examples.
• Broken references: select the intended cells in the formula editor instead of guessing a reference from an Excel workbook. An error, rather than TRUE/FALSE, requires checking the source cell and formula editor.

Excel and Google Sheets also provide an EXACT function for case-sensitive text comparisons, but coercion, imported values and locale choices need separate testing before moving a workbook. Numbers formulas are table-relative rather than Excel’s default worksheet-relative model; references to another Numbers table can require Table Name::A2. Unlike an ordinary equal-sign comparison, EXACT explicitly tests the case/content described by Apple.

This page follows Apple’s English Formulas and Functions Help 15.4 documentation, checked 2026-10-11. That is a documentation version, not proof of the first Numbers release that supported this function. Apple describes its Functions Browser for Numbers on Mac, iPhone, iPad and iCloud.com; the cited function reference does not specify a separate minimum installed version for this function or certify that all device editions behave identically. Mac, iPhone, iPad and web execution were not tested here.

• In the example table, a formula placed in the same table can use A2, B2 or A2:A6. For another Numbers table, the explicit form can be Products::A2 or Sheet 2::Products::A2 where disambiguation is needed. Use the built-in reference picker to avoid errors.
• Apple’s English documentation separates arguments with commas. With a comma decimal separator configuration, Apple instructs you to use semicolons as function argument separators when typing by hand, such as =EXACT(A2;B2). This does not alter punctuation inside quoted text.
• The examples are illustrative content, not screenshots and not proof of live application execution.

• COUNTIF: counting status labels
• REGEX.EXTRACT: extracting text patterns

Internal related-guide URLs should be confirmed in the final site build; the source documentation is linked above.

• Apple Numbers — function documentation
• Apple Functions Overview
• Apple: Refer to cells in formulas
• Apple Formulas and Functions Help

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

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.