How to Use the INT Function in WPS on Windows

Use the INT function in WPS Spreadsheet on Windows with 3 how-to topics, including inserting the function, typing the formula directly, and checking syntax guidance.

How-to Index

How-to Guide

1. Insert INT from the Insert Function dialog box

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

Success Criteria

• The current cell contains the INT function.
• The formula bar shows the =INT(...) structure.
• The cell returns an integer result when the parameter is valid.

Tips While Using

• You can search for the function name in uppercase or lowercase, but the spelling must stay correct.
• The parameter should be a number or a reference that evaluates to a number.

2. Type the formula directly in a cell

Entry point: Cell or formula bar

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

Success Criteria

• The cell shows the INT calculation result.
• When you select the cell, the formula bar shows the full formula.
• The formula can be filled down or copied to other cells.

Tips While Using

• The formula must start with an equals sign (=).
• Use standard English punctuation in the formula to avoid calculation errors.

3. Check the function syntax and parameter guidance

Entry point: Formulas tab → Insert Function

1. Click Insert Function on the Formulas tab.
2. Enter INT in the search box.
3. Select the function and review the syntax INT(number).
4. Open the related help entry if you need more detailed parameter guidance.

Success Criteria

• You can see the INT function name and syntax structure.
• You can confirm the input requirement for the number parameter.
• You can return to the worksheet and continue entering the formula.

Tips While Using

• If the result is not what you expect, first check whether the referenced cell contains a numeric value.
• For negative numbers, INT rounds toward the smaller integer.