How to Use the EXACT Function in WPS on Windows

Last updated:July 20, 2026

Use the EXACT function through 4 how-to topics, with 4 free topics and 0 membership-related topics; start from the How-to Index to jump to the task you need.

How-to Index

No.TopicMembership Requirement
11. Enter the EXACT functionFree
22. Review syntax tips and fill in argumentsFree
33. Use cross-sheet referencesFree
44. Use EXACT inside a nested formulaFree

How-to Guide

1. Enter the EXACT function

Entry point: Formula tab → formula bar

  1. Open WPS Spreadsheet and go to the worksheet where you want the result.
  2. Select the cell that should display the result.
  3. Type = to start a formula.
  4. Type EXACT(.
  5. Enter the two text arguments you want to compare.
  6. Press Enter to calculate the result.

Success Criteria

  • On-screen result: The selected cell returns a comparison result.
  • Next action available: You can edit the arguments or copy the formula to other cells.

Tips While Using

  • Common mistake: If you do not start with =, the entry is treated as plain text.
  • Environment note: You need to work in an editable cell.

2. Review syntax tips and fill in arguments

Entry point: Formula bar → function input tip

  1. Type =EXACT( in a worksheet cell.
  2. Review the syntax tip shown by the app.
  3. Enter the first argument.
  4. Add the separator and enter the second argument.
  5. Check that the closing parenthesis is complete.
  6. Press Enter to finish.

Success Criteria

  • On-screen result: A syntax tip appears while you enter the function.
  • Next action available: The formula can return TRUE, FALSE, or the expected result state.

Tips While Using

  • Common mistake: Missing arguments or an incomplete parenthesis can cause a formula error.
  • Environment note: The separator may vary by regional settings, so follow the one shown in your interface.

3. Use cross-sheet references

Entry point: Target cell → formula bar

  1. Select the result cell and type =EXACT(.
  2. Click the target cell in the first worksheet for the first argument.
  3. Enter the argument separator.
  4. Switch to another worksheet and select the second argument cell.
  5. Add the closing parenthesis.
  6. Press Enter to view the comparison result.

Success Criteria

  • On-screen result: The formula includes references from more than one worksheet.
  • Next action available: If either referenced cell changes, the result updates automatically.

Tips While Using

  • Common mistake: After switching sheets, selecting the wrong cell can create an incorrect reference.
  • Environment note: The referenced worksheets must be accessible in the current workbook.

4. Use EXACT inside a nested formula

Entry point: Result cell → formula bar

  1. Select the cell where you want the final result.
  2. Enter a combined formula that includes EXACT, such as a conditional formula.
  3. Fill in the two text arguments inside EXACT.
  4. Complete the remaining arguments of the outer formula.
  5. Check that all separators and parentheses are complete.
  6. Press Enter to return the final result.

Success Criteria

  • On-screen result: The cell returns the final output of the nested formula.
  • Next action available: You can copy the formula, fill it down, or adjust the logic.

Tips While Using

  • Common mistake: It is easy to miss a parenthesis when the formula has multiple layers.
  • Environment note: For longer formulas, editing in the formula bar is easier to review.