XIRR in WPS on Windows: Introduction

XIRR in WPS is a financial function in WPS Spreadsheet for calculating the internal rate of return for irregular cash flows; this guide covers 4 core tasks, with 4 available without membership and 0 membership-related items.

At a Glance

Metric	Value	Notes
Core tasks	4	Matches the number of rows in the How-to Index
Available without membership	4	Matches the number of Free rows in the index
Membership-related items	0	Matches the number of membership-related rows in the index
Recommended version	Latest WPS Office	Helps provide a stable formula editing experience in WPS Spreadsheet

About This Feature

Overview

XIRR is a built-in financial function in WPS Spreadsheet on Windows for calculating the internal rate of return for cash flows that occur on irregular dates.

Its main capabilities include:

Entering =XIRR( directly in a worksheet cell to start the formula and view syntax hints.
Using the values, dates, and optional guess arguments for different investment analysis scenarios.
Referencing cells and ranges in an existing cash flow table.
Recalculating results after source data changes.

This function is useful for investment return analysis, project cash flow reviews, and financial modeling checks. It helps reduce manual trial-and-error when cash flow dates are not evenly spaced. In WPS Spreadsheet, the function can be entered directly in a cell and used with existing worksheet data.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula calculation; internet access is needed for download, installation, and account services
Other	You need a worksheet with cash flow amounts and matching date values

Download & Installation

Item	Details
Official download	WPS Office Free Download
Installation	Download the Windows installer and complete setup by following the on-screen prompts
Post-install check	Open WPS Spreadsheet, select any cell, and type `=XIRR(` to confirm that the function hint appears

Source: WPS download page

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	WPS Spreadsheet supports entering the XIRR function with amount and date arguments to calculate the internal rate of return for irregular cash flows, and syntax hints appear during formula entry.	Excel provides the XIRR function to return the internal rate of return for a schedule of cash flows that is not necessarily periodic, with the syntax `XIRR(values, dates, [guess])`.	Google Sheets provides the XIRR function to calculate the internal rate of return for irregular cash flows, with the syntax `XIRR(cashflow_amounts, cashflow_dates, [rate_guess])`.	Notion provides database formulas and functions for property-based calculations, but its official help content does not present a spreadsheet-style XIRR equivalent.	Adobe Acrobat supports calculations in PDF form fields, such as predefined sum or average operations, but it does not provide a spreadsheet XIRR financial function.
WPS Advantages	Advantage: You can enter XIRR directly in a worksheet cell and calculate against existing ranges in a spreadsheet workflow. Distinct: It fits irregular cash flow analysis in a spreadsheet environment.	Compared with WPS: Excel also provides a native XIRR function with a similar function scope.	Compared with WPS: Google Sheets also provides a native XIRR function for spreadsheet-based calculations in the browser.	Compared with WPS: Notion focuses on database property formulas rather than cell-based spreadsheet functions.	Compared with WPS: Acrobat focuses on PDF form calculations rather than spreadsheet financial functions.
Official Source	—	Excel XIRR function	Google Sheets XIRR	Notion formula syntax	Acrobat form field calculations

Overall Conclusion
For irregular cash flow return analysis in a spreadsheet, WPS, Excel, and Google Sheets all provide a direct XIRR function workflow. Notion and Adobe serve adjacent database or PDF form scenarios rather than the same spreadsheet function experience.

Source: WPS XIRR function guide

Use Cases

No.	Scenario	Suitable for	Main challenge	How XIRR helps
1	Investment return analysis	Finance staff	Cash flow dates are irregular, so periodic return functions are not suitable	Use XIRR with amount and date ranges to calculate the return
2	Project review analysis	Operations and project teams	Actual payment dates change the return picture over time	Update the cash flow data and recalculate XIRR
3	Training and practice	Students and trainees	Users need to learn the syntax of irregular cash flow functions	Type `=XIRR(` in a cell and follow the parameter hint
4	Reusable finance templates	Office users	Existing templates need a reusable return formula	Apply XIRR with cell references in the worksheet
5	Multi-stage funding plans	Small teams and managers	Multiple investments and returns are spread across different dates	Organize amounts and dates into ranges and calculate with XIRR

Membership & Benefits

Free vs WPS Premium

Capability	Free users	WPS Premium
XIRR formula entry and calculation	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Advanced PDF editing and conversion	Partially limited	More advanced capabilities available
Cloud storage	1 GB	20 GB in some plans
AI tools	Some limits apply	More usage or broader access available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
You mainly need XIRR and everyday spreadsheet calculations	Free plan	The XIRR function itself is available without membership
You also need more PDF, cloud storage, or AI capabilities	WPS Premium	Better suited for broader office needs beyond basic spreadsheet work

WPS membership center: Subscribe now