EXACT in WPS on Windows FAQ

Last updated:July 20, 2026

Common questions about the EXACT function usually involve syntax entry, result interpretation, references, and recalculation; this FAQ covers 4 frequent questions.

FAQ

What should I do if the EXACT function shows an error?

  1. Check whether the formula starts with =.
  2. Confirm that the function name is spelled EXACT.
  3. Make sure the parentheses are paired correctly.
  4. Check that the separator between the two arguments is correct.
  5. Press Enter again to recalculate.

How can I view the argument guide for the EXACT function?

  1. Select any editable cell.
  2. Type =EXACT(.
  3. Review the syntax tip that appears automatically.
  4. Enter the arguments in the order shown.

Why does the EXACT result not match what I expected?

  1. Check whether the two text values differ in letter case.
  2. Check for extra spaces or hidden characters.
  3. Confirm that the referenced cells are the correct ones.
  4. Review the original data again if needed.

Why does the result not update as expected after I change the data?

  1. Confirm that the formula cell still contains a formula rather than fixed text.
  2. Check whether the edited value is in the referenced cell.
  3. Make sure the formula structure was not changed accidentally.
  4. Re-enter the formula and test again if necessary.

Glossary

TermDefinition
EXACTA spreadsheet function that checks whether two text values are completely identical.
ArgumentAn input used by a function, such as the two text values compared by EXACT.
Cross-sheet referenceA formula reference that points to a cell in another worksheet.
Nested formulaA formula structure that places one function inside another.