How to Use the EVEN Function in WPS on Windows

Last updated:July 23, 2026

Use EVEN through 3 practical topics: create a formula field and call EVEN, review the parameter format, and save a basic example; 3 topics are free and 0 are membership-related.

How-to Index

No.TopicMembership Requirement
11. Create a formula field and call EVENFree
22. Review the EVEN parameter formatFree
33. Write and save an EVEN example formulaFree

How-to Guide

1. Create a formula field and call EVEN

Entry: Add Field → Formula

  1. Open the multi-dimensional table that you want to edit.
  2. Click Add Field on the toolbar.
  3. Select Formula as the field type.
  4. Enter a formula that includes EVEN in the formula editor.
  5. Click Confirm to save the setting.

Success Criteria

  • Interface result: a new formula field appears in the table.
  • What you can do next: you can view the calculated result in that field.

Tips While Using

  • Common mistake: if you do not choose the Formula field type, you cannot enter a function formula.
  • Environment note: you need permission to edit the current multi-dimensional table.

2. Review the EVEN parameter format

Entry: Formula Editor → Function Library → EVEN

  1. Open the formula editor in a formula field.
  2. Find EVEN in the function library.
  3. Review the function format.
  4. Enter the target number or reference as needed.

Basic format:

EVEN(number)

Success Criteria

  • Interface result: the formula editor shows the EVEN function name and format.
  • What you can do next: you can continue entering the parameter and save the formula.

Tips While Using

  • Common mistake: if the parameter is not numeric, the result may not calculate as expected.

3. Write and save an EVEN example formula

Entry: Formula Editor

  1. Create or select a formula field.
  2. Enter an example such as EVEN(3) in the editor.
  3. Click Confirm to save it.
  4. Check the returned result in the field.
  5. Replace the sample value with a real field reference or number when needed.

Success Criteria

  • Interface result: the field shows the rounded even-number result.
  • What you can do next: when the input value changes, the result can update with it.

Tips While Using

  • Common mistake: if parentheses or parameters are incomplete, the formula may return an error.
  • Environment note: if you reference another field, make sure that field contains a numeric value that can be calculated.