How to Use the FLOOR Function in WPS on Windows

This section includes 3 how-to topics: creating a formula field and calling FLOOR, checking the parameter format, and writing a working example; all 3 topics are available without membership.

How-to Index

How-to Guide

1. Create a formula field and call FLOOR

Entry point: Add Field → Formula

1. Open the multidimensional table that you want to edit.
2. Click Add Field.
3. Select Formula as the field type.
4. Enter a formula that includes FLOOR in the formula editor.
5. Click Confirm and check whether the calculated result appears in the field.

Success Criteria

• A formula field has been added successfully.
• The field shows a FLOOR calculation result.
• You can continue editing other fields after saving.

Tips While Using

• Make sure the referenced data can be used in numeric calculations before entering the formula.
• If the result looks wrong, check the function name, parentheses, and parameter separators first.

2. Check the parameter format

Entry point: Formula Editor → Function Library → FLOOR

1. Open the formula editor.
2. Find FLOOR in the function library.
3. Review the function format and parameter description.
4. Fill in the parameters based on your current business needs.

You can use this structure as a reference:

FLOOR(
  parameter1,
  parameter2
)

Success Criteria

• You have found the FLOOR function entry.
• You understand where to place the parameters.
• You can continue writing the formula as needed.

Tips While Using

• Keep the number and order of parameters consistent with the function description.
• When referencing fields or values, make sure the format matches the current table rules.

3. Write and verify an example

Entry point: Formula field editor

1. Enter a sample FLOOR formula in the formula field.
2. Replace the sample parameters with your own business data.
3. Save the formula and check whether the result refreshes automatically.
4. If you need more complex logic, combine FLOOR with other functions.

Example:

FLOOR(target_value, specified_multiple)

Success Criteria

• The sample formula can be saved normally.
• The result updates when record data changes.
• The formula can be extended for nested or broader calculations.

Tips While Using

• Test with a small amount of sample data first.
• Formula field results are calculated values, so changes in source data will update the result.