How to Use the LOWER Function in WPS on Windows

Last updated:July 23, 2026

Use LOWER through 3 how-to topics, including creating a formula field, checking the parameter format, and validating an example formula.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call LOWERFree
22. Check the parameter formatFree
33. Write and verify an exampleFree

How-to Guide

1. Create a formula field and call LOWER

Entry: Add Field → Formula

  1. Open the Bitable you want to edit.
  2. Click Add Field.
  3. Select Formula as the field type.
  4. Enter a formula that includes LOWER in the editor.
  5. Click Confirm to save the setting.

Success Criteria

  • Interface result: A new formula field appears in the table.
  • Next action available: You can continue editing the function in the formula editor.

Tips While Using

  • Common mistake: If you choose the wrong field type, you may not be able to enter a formula.
  • Environment note: You need edit permission for the current table.

2. Check the parameter format

Entry: Formula Editor → Function Library → LOWER

  1. Open the formula editor in an existing formula field.
  2. Go to the function library and find LOWER.
  3. Review the function syntax and parameter format.
  4. Enter the target text or reference as needed.

Success Criteria

  • Interface result: You can see the LOWER function name and parameter format.
  • Next action available: You can continue writing the formula based on the displayed guidance.

Tips While Using

  • Common mistake: If the reference format is incorrect, the result may not return as expected.

3. Write and verify an example

Entry: Formula Editor

  1. Enter an example formula in the formula field, such as LOWER(target_range).
  2. Confirm that the referenced content is the text you want to convert.
  3. Save the formula and review the field result.
  4. Adjust the reference or combine functions further if needed.

Success Criteria

  • Interface result: The formula field shows a lowercase result.
  • Next action available: When source data changes, the result can update with it.

Tips While Using

  • Common mistake: If the parameter does not point to the intended text, the result may not match your expectation.
  • Environment note: Different field content can affect the displayed result.