How to Use the EVEN Function in WPS on Windows

Use the EVEN function through 3 operation topics in WPS Spreadsheet; all 3 are available without membership and 0 are membership-related.

How-to Index

How-to Guide

1. Enter the function from the Insert Function dialog box

Entry point: Formula tab → Insert Function

1. Select the cell where you want to enter the formula.
2. Click the fx button in the formula bar, or click Insert Function on the Formula tab.
3. Search for EVEN in the Insert Function dialog box.
4. Select the function and click OK.
5. Enter the parameter in the Function Arguments dialog box.
6. Click OK to finish inserting the function.

Success Criteria

• The current cell contains the EVEN function.
• The formula returns an even-number rounding result.

Tips While Using

• The parameter should be a number or a cell reference that can be evaluated as a number.
• If the input is not numeric, the result may show #VALUE!.

2. Type the formula directly in a cell

Entry point: Cell → Formula bar

1. Select the cell where you want to enter the formula.
2. Type =EVEN(...) directly in the cell or in the formula bar.
3. Press Enter to confirm.
4. If you want to review the parameter hint, type =EVEN( and press F1.

Success Criteria

• The cell shows a calculated result.
• The full EVEN formula is visible in the formula bar.

Tips While Using

• Use English parentheses after the function name.
• Use English punctuation for separators.

3. View the syntax and parameter details

Entry point: Formula tab → Insert Function

1. Click Insert Function on the Formula tab.
2. Type EVEN in the search box.
3. Select the function and review the syntax EVEN(number).
4. Click the help link for the function to view more details.

Success Criteria

• You can see the function name, syntax, and parameter description.
• You can confirm where the number parameter should be entered.

Tips While Using

• The parameter name in the syntax explains the format. Replace it with a number or a cell reference when entering the formula.