How to Use the EXACT Function in WPS on Windows

Last updated:July 20, 2026

This how-to guide includes 3 topics for using EXACT, covering function entry, syntax prompts, and result recalculation; choose a topic from the index and follow the steps.

How-to Index

No.TopicMembership
11. Enter the EXACT functionFree
22. View the function syntax promptFree
33. Check results and recalculateFree

How-to Guide

1. Enter the EXACT function

Entry point: Formulas tab → formula bar

  1. Open WPS Spreadsheets and select the cell where you want to enter the formula.
  2. Type = in the formula bar or directly in the cell.
  3. Type EXACT( to begin the formula.
  4. Enter the two text arguments you want to compare, then press Enter.

Success Criteria

  • On-screen result: The cell shows a comparison result such as TRUE or FALSE.
  • What you can do next: You can continue editing arguments, copy the formula, or fill it down.

Tips While Using

  • Common mistake: Missing parentheses, commas, or quotation marks can cause a formula error.
  • Environment note: You need an editable spreadsheet cell to enter the formula.

2. View the function syntax prompt

Entry point: formula bar

  1. Select the target cell.
  2. Type =EXACT(.
  3. Watch for the syntax prompt that appears automatically.
  4. Review the argument requirements and example, then continue entering the formula.

Success Criteria

  • On-screen result: A parameter prompt appears after you type the function name.
  • What you can do next: You can complete the arguments based on the prompt and finish the formula.

Tips While Using

  • Common mistake: If the function name is misspelled, the syntax prompt may not appear.
  • Environment note: Entering the formula in the formula bar can make the full prompt easier to read.

3. Check results and recalculate

Entry point: result cell / keyboard shortcut

  1. Review the current result after entering the EXACT formula.
  2. Change the content in a referenced text cell.
  3. Check whether the result updates automatically.
  4. If needed, press F9 to recalculate manually. On some devices, you may need Fn+F9.

Success Criteria

  • On-screen result: The result updates after the referenced text changes.
  • What you can do next: You can continue checking other cells or copy the existing formula.

Tips While Using

  • Common mistake: If a referenced cell contains unexpected text formatting, the result may differ from what you expect.
  • Environment note: The manual recalculation shortcut can vary depending on keyboard settings.