WPS Features
Resources
Free AI Tools
Docs Center

How to Use the EXACT Function in WPS on Windows

Last updated:July 13, 2026

Use the EXACT function through 3 how-to topics, including inserting it from the function dialog box, typing the formula directly, and reviewing syntax and parameters; 3 items are available without membership and 0 are membership-related.

How-to Index

#TopicMembership
11. Enter the function from the Insert Function dialog boxFree
22. Type the formula directly in a cellFree
33. Review the function syntax and parametersFree

How-to Guide

1. Enter the function from the Insert Function dialog box

Entry point: Formula tab → Insert Function

  1. Select the cell where you want to enter the formula.
  2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
  3. Search for EXACT in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog box.
  6. Click OK to finish entering the function.

Success Criteria

  • UI state: The target cell shows the EXACT formula or its calculated result.
  • Next actions: You can continue editing parameters, press Enter to confirm, or fill the formula down.

Tips While Using

  • Common mistakes: A misspelled function name can make EXACT harder to find in the search box.
  • Environment limits: Open a WPS Sheets worksheet first and make sure the target cell is editable.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

  1. Select the cell where you want to enter the formula.
  2. Type =EXACT(...) directly in the cell or the formula bar.
  3. Press Enter to confirm.
  4. If you want to review parameter guidance, type =EXACT( and press F1 to check the syntax prompt.

Success Criteria

  • UI state: The cell returns TRUE, FALSE, or shows the formula while you edit it.
  • Next actions: You can copy the formula, drag the fill handle, or adjust the referenced cells.

Tips While Using

  • Common mistakes: Incomplete separators, parentheses, or quotation marks can prevent the formula from calculating correctly.
  • Environment limits: Keyboard input needs to work normally in the current Windows and app session.

3. Review the function syntax and parameters

Entry point: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Type EXACT in the search box.
  3. Select the function and review the syntax and parameter area.
  4. If you need more detail, review the help information and then return to the worksheet to enter the formula.

Success Criteria

  • UI state: You can see the EXACT function name, parameter positions, and related guidance.
  • Next actions: You can move directly to parameter entry or return to the cell and continue editing.

Tips While Using

  • Common mistakes: Closing the window before selecting the function may prevent you from seeing the full parameter details.
  • Environment limits: The way help information appears can vary with the current interface layout.