WPS Features
Resources
Free AI Tools
Docs Center

How to Use

Last updated:July 8, 2026

Use ABS in 3 how-to topics, including inserting the function, typing the formula directly, and checking syntax details; 3 topics are available without membership and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Insert ABS from Insert FunctionFree
22. Type the ABS formula directly in a cellFree
33. Check ABS syntax and parameter detailsFree

How-to Guide

1. Insert ABS from Insert Function

Entry: Formula tab → Insert Function, or the fx button in the formula bar

  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 ABS in the Insert Function dialog box.
  4. Select the function and click OK.
  5. Enter the parameter in the Function Arguments dialog box.
  6. Click OK to finish inserting the function.

Success Criteria

  • The current cell contains the ABS function.
  • The formula structure is visible in the formula bar.
  • The result cell returns the absolute value.

Tips While Using

  • The parameter should be a number or a numeric cell reference.
  • If the parameter contains text or extra spaces, the result may not match your expectation.

2. Type the ABS formula directly in a cell

Entry: Worksheet cell → Formula bar

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

Success Criteria

  • The cell shows the calculation result.
  • The full formula remains visible in the formula bar.
  • The formula works after you press Enter.

Tips While Using

  • Use standard formula punctuation when entering the parameter.
  • When you reference another cell, confirm that the reference points to the correct location.

3. Check ABS syntax and parameter details

Entry: Formula tab → Insert Function

  1. Click Insert Function on the Formula tab.
  2. Type ABS in the search box.
  3. Select the function and review the syntax ABS(number).
  4. Click the help link for the function to view more details.

Success Criteria

  • You can see the ABS function name and syntax.
  • You have confirmed that the parameter name is number.
  • You can return to the worksheet and continue entering the formula.

Tips While Using

  • The syntax description helps you confirm the parameter format, but it does not replace an existing formula automatically.
  • After checking the help details, you can return to the worksheet and continue editing.