Create a Reusable Custom Rounding Function in WPS Spreadsheets
Question details
The user wants to create a reusable rounding formula in WPS Spreadsheets that rounds odd values up and even values down without rewriting the formula or using VBA.
- Product
- WPS Spreadsheets
- Device & OS
- not provided
- Scenario
- The user is working with numeric data and needs to apply the same odd-up/even-down rounding rule to different cells.
- Observed behavior
- The goal is to store a single named formula such as =RoundCustom(F3) that can be used repeatedly.
Before defining the custom function, confirm that your WPS Spreadsheets version supports LAMBDA, and open the Name Manager from the Formulas tab in the workbook where the formula should be reused.
Define a reusable rounding function with Name Manager and LAMBDA in WPS Spreadsheets
Use this method when you want to store the odd-up/even-down rounding rule once and reuse it as =RoundCustom(F3) across the workbook.
Name Manager stores workbook-level names, and LAMBDA wraps the odd-up/even-down rounding logic into one reusable function. Once saved, you only need to change the input cell reference instead of rewriting the formula.
In WPS Spreadsheets, go to the Formulas tab and click Name Manager.
Click New, enter the name RoundCustom, and leave the scope set to Workbook.
In the Refers to box, type =LAMBDA(x,IF(ISODD(x),CEILING(x,1),FLOOR(x,1))) and click OK.
In any cell, enter =RoundCustom(F3) or another cell reference to apply the rounding rule.
Type an odd number and an even number in the referenced cell to confirm that odd values round up and even values round down.
Save the Odd-Up/Even-Down Rounding Rule as RoundCustom in WPS Spreadsheets
Use WPS Spreadsheets Name Manager and LAMBDA to save the odd-up/even-down rounding rule as a reusable named function, then call it with =RoundCustom(cell).
- 1. Open WPS Spreadsheets: Download and open WPS Office, then create or open an .xlsx workbook.
- 2. Open Name Manager: Click the Formulas tab and select Name Manager.
- 3. Create the named function: Click New, name it RoundCustom, and enter =LAMBDA(x,IF(ISODD(x),CEILING(x,1),FLOOR(x,1))) in the Refers to box.
- 4. Use the function: Type =RoundCustom(F3) in any cell to round the referenced value.
- 5. Save the workbook: Save the file in .xlsx format to keep the named function available.
Frequently Asked Questions
Do I need VBA to create a reusable rounding function in WPS Spreadsheets?
No. You can define a named formula with LAMBDA in Name Manager and reuse it like =RoundCustom(F3).
What does =LAMBDA(x,IF(ISODD(x),CEILING(x,1),FLOOR(x,1))) do?
It checks whether the input value is odd. If it is odd, CEILING rounds it up; if it is even, FLOOR rounds it down.
Can I reuse RoundCustom in other workbooks?
The named function is saved in the workbook where it is defined. To use it elsewhere, define it in that workbook or copy the name through Name Manager.
What should I do if WPS Spreadsheets does not support LAMBDA?
Update WPS Office to a recent version, or use the direct formula =IF(ISODD(F3),CEILING(F3,1),FLOOR(F3,1)) in each cell.
Where is Name Manager in WPS Spreadsheets?
Open the Formulas tab and click Name Manager to view, create, or edit named formulas.
