How to Use the INT Function in WPS on Windows

Use the INT function in WPS with 4 how-to topics, all available without membership; choose a topic from the How-to Index and follow the entry path and steps to complete the task.

How-to Index

How-to Guide

1. Enter the INT function

Entry path: Formulas tab → formula bar

1. Open WPS Spreadsheet and select the cell where you want to show the result.
2. Type = in the formula bar or directly in the cell.
3. Continue by typing INT(.
4. Check the function prompt to confirm that the INT function input state is active.

Success Criteria

• On-screen result: a function or parameter prompt appears after you type INT(.
• Next action available: you can continue entering the parameter and complete the formula.

Tips While Using

• Common mistake: if you do not type = first, the content may be treated as plain text.
• Environment note: this action needs to be done in WPS Spreadsheet.

2. Fill in the parameter as prompted

Entry path: formula bar

1. After INT(, enter the number, cell reference, or expression that you want to round down.
2. Check that the parentheses are complete.
3. Press Enter to confirm the formula.
4. Review the integer result in the cell.

Success Criteria

• On-screen result: the target cell shows the INT calculation result.
• Next action available: you can copy the formula to other cells.

Tips While Using

• Common mistake: unmatched parentheses or an invalid parameter format can cause a formula error.
• Environment note: the parameter needs to be a calculable number or expression.

3. Use INT in a cross-sheet formula

Entry path: formula bar

1. Select the target cell and type =INT(.
2. Switch to another worksheet and select the cell or range expression that you want to reference.
3. Complete the closing parenthesis and confirm the formula.
4. Press Enter to review the integer result.

Success Criteria

• On-screen result: the formula includes a cross-sheet reference and returns a normal result.
• Next action available: when the referenced data changes, the result can update accordingly.

Tips While Using

• Common mistake: an incorrect reference can produce an unexpected result.
• Environment note: the referenced worksheet must be accessible in the current file.

4. Use INT in a nested formula

Entry path: formula bar

1. In the target cell, enter the framework of a formula that already includes another function.
2. Wrap the part that needs rounding with INT().
3. Check the order of parameters and all parentheses.
4. Press Enter to confirm and review the result.

Success Criteria

• On-screen result: the nested formula returns an integer result normally.
• Next action available: you can continue editing the outer formula or copy it to another range.

Tips While Using

• Common mistake: incorrect parenthesis levels in a multi-layer formula can cause calculation failure.
• Environment note: for longer formulas, editing in the formula bar is easier to review.