How to Use the FLOOR Function in WPS on Windows

Use the FLOOR function through 4 how-to topics, all available without membership; choose a topic from the index and follow the entry point and steps.

How-to Index

How-to Guide

1. Enter the FLOOR function

Entry point: Formula tab → formula editing bar

1. Open WPS AirSheet and select the cell where you want to enter the formula.
2. Type = in the cell or formula bar to start the formula.
3. Enter FLOOR(.
4. Review the syntax prompt before entering parameters.

Success Criteria

• UI state: The cell enters formula editing mode and shows FLOOR(.
• Next actions: You can continue entering parameters and complete the formula.

Tips While Using

• Common mistakes: If you do not type = first, the content may be treated as plain text.
• Environment limits: You need to be in an editable spreadsheet cell.

2. Fill in parameters with the prompt

Entry point: Current cell or formula bar

1. After FLOOR(, enter the value or cell reference to calculate.
2. Follow the syntax prompt to enter the separator and the second parameter.
3. Check that the parameter types and count are correct.
4. Press Enter to confirm the formula.

Success Criteria

• UI state: The cell displays a calculation result.
• Next actions: When you select the cell again, the full formula is visible in the formula bar.

Tips While Using

• Common mistakes: Unmatched parentheses or missing separators can cause an error.
• Environment limits: Different data formats may affect the displayed result, so check the cell format when needed.

3. Use cross-sheet references or nested formulas

Entry point: Formula bar

1. Select the target cell and type =.
2. Enter a formula that includes FLOOR.
3. Reference cells from another sheet in the parameters, or combine FLOOR with other functions.
4. Press Enter to finish the calculation.

Success Criteria

• UI state: The target cell returns a calculation result.
• Next actions: After you change a referenced cell, you can continue checking the updated result.

Tips While Using

• Common mistakes: An incorrect cross-sheet reference range can produce unexpected results.
• Environment limits: If the nested formula is long, edit it in the formula bar for easier review.

4. Check automatic recalculation results

Entry point: Result cell with an existing formula

1. Change the source data referenced by the FLOOR formula.
2. Check whether the result cell updates at the same time.
3. If the result does not change as expected, check for numbers stored as text or circular references.
4. If needed, trigger recalculation manually and confirm the result again.

Success Criteria

• UI state: The result cell updates after the source data changes.
• Next actions: You can continue saving, copying, or extending the formula to other cells.

Tips While Using

• Common mistakes: Numbers stored as text may cause unexpected calculation results.
• Environment limits: In complex sheets, circular references should be checked first.