How to Use the CEILING Function in WPS on Windows

Last updated:July 15, 2026

This how-to guide includes 3 operation topics for using CEILING in WPS Spreadsheet, with 3 available without membership and 0 membership-related items.

How-to Index

No.TopicMembership Requirement
11. Enter CEILING from the Insert Function dialogFree
22. Type the formula directly in a cellFree
33. Review the syntax and parameter detailsFree

How-to Guide

1. Enter CEILING from the Insert Function dialog

Entry point: Formulas 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 Formulas tab.
  3. Search for CEILING in the Insert Function dialog.
  4. Select the function and click OK.
  5. Enter each parameter in the Function Arguments dialog.
  6. Click OK to finish entering the function.

Success Criteria

  • Interface result: The target cell now contains the CEILING function.
  • What you can do next: You can continue editing parameters, press Enter to confirm, or copy the formula to other cells.

Tips While Using

  • Use English commas to separate parameters.
  • Make sure the parameters are numeric so the calculation works as expected.

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 =CEILING(...) directly in the cell or in the formula bar.
  3. Press Enter to confirm.
  4. If you want to review parameter hints, watch the formula prompt after typing the opening parenthesis.

Success Criteria

  • Interface result: The cell returns the rounded-up calculation result.
  • What you can do next: You can fill down, copy the formula, or continue editing the parameters.

Tips While Using

  • If the result looks incorrect, check whether number and significance were entered correctly.
  • When copying the formula across cells, pay attention to relative and absolute references.

3. Review the syntax and parameter details

Entry point: Formulas tab → Insert Function

  1. Click Insert Function on the Formulas tab.
  2. Type CEILING in the search box.
  3. Select the function and review the syntax CEILING(number, significance).
  4. Enter the value and significance based on the parameter descriptions, then complete the insertion.

Success Criteria

  • Interface result: You can see the function name, syntax structure, and parameter input area.
  • What you can do next: You can insert the function directly from the parameter window.

Tips While Using

  • significance defines the multiple used for rounding.
  • Before applying the formula to a large range, test it with sample data first.