AMORDEGRC in WPS on Windows: Introduction

AMORDEGRC is a financial depreciation function in WPS Spreadsheets for Windows that helps calculate depreciation for each accounting period; 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

About This Feature

Overview

AMORDEGRC is a built-in function in WPS Spreadsheets on Windows for depreciation calculations, fixed-asset analysis, and accounting worksheets. When you enter the function name, WPS can show syntax guidance, parameter hints, and examples in the formula bar, then return the calculation result directly in the selected cell.

Core capabilities include:

Enter =AMORDEGRC( to view syntax guidance and reduce formula entry errors.
Fill in the required arguments and return the depreciation result directly in a cell.
Use cross-sheet references to pull data from other worksheets in the same workbook.
Support nested formulas and automatic recalculation when source data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	The latest version of WPS Office is recommended
Network	No mandatory internet connection is required for local formula calculation; downloading, installation, and account actions require internet access
Other	You need to open a spreadsheet file and have permission to edit cell formulas

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Open WPS Spreadsheets, select any cell, and enter `=AMORDEGRC(` to confirm that function guidance appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	Enter the AMORDEGRC function directly in WPS Spreadsheets with syntax guidance, argument entry, cross-sheet references, and automatic recalculation.	Excel provides Formula AutoComplete to display valid functions, names, and argument guidance while users enter formulas.	Google Sheets supports formulas and functions in spreadsheet cells, shows a function help box during editing, and supports nested functions and formula suggestions.	Notion formulas work mainly in database properties and support functions, built-ins, and property-based calculations rather than traditional spreadsheet cell formulas.	Acrobat can configure calculated PDF form fields with predefined calculations or custom calculation logic for form workflows.
WPS Advantages	Advantage: closer to everyday spreadsheet cell entry for depreciation workbooks; Distinct: suitable for fixed-asset depreciation calculations that update with source data changes.	Compared with WPS: Microsoft’s official page highlights formula entry assistance, but this page does not focus on a single depreciation function workflow such as AMORDEGRC.	Compared with WPS: Google Sheets supports spreadsheet formulas and help prompts, but the official guidance here is broader formula help rather than a dedicated AMORDEGRC-style function workflow in WPS.	Compared with WPS: Notion formulas are designed for database properties and workspace logic, not for direct cell-based financial function entry in a spreadsheet grid.	Compared with WPS: Adobe calculation features are designed for PDF form fields, so the workflow differs from spreadsheet-based financial analysis and formula editing.
Official Source	—	Use Formula AutoComplete	Add formulas & functions	Intro to formulas	Configure form field calculations in Acrobat

Overall Conclusion

If your main task is entering depreciation formulas, filling arguments, and updating results inside spreadsheet cells, WPS provides a workflow that fits routine spreadsheet work well. Notion and Adobe are useful for database logic and PDF form calculations, but their official workflows are different from cell-based financial functions in a spreadsheet.

Use Cases

No.	Scenario	Suitable For	Core Need	How WPS Helps
1	Fixed-asset depreciation estimates	Finance staff	Calculate depreciation by accounting period	Enter the AMORDEGRC function in a cell to calculate depreciation
2	Asset ledger organization	Admin and asset managers	Reduce manual calculation errors across multiple fields	Use cross-sheet references to pull source data together
3	Report review	Auditors and reviewers	Recheck results after data changes	Use automatic recalculation to refresh results quickly
4	Complex worksheet models	Advanced spreadsheet users	Combine multiple calculation methods	Nest AMORDEGRC with other functions
5	Training and teaching	Students and instructors	Demonstrate how a financial function is entered	Use syntax guidance to explain the argument structure

Membership & Benefits

Free vs WPS Premium

Capability	Free Users	WPS Premium
AMORDEGRC function entry and calculation	✅ Available	✅ Available
Basic PDF features	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Template downloads	Limited	More advanced templates and added benefits
AI tools	Limited access to some features	More AI features and higher usage allowance

Source: WPS Office pricing page

Recommendations

Scenario	Recommended Plan	Why
You mainly need AMORDEGRC and other basic spreadsheet functions	Free	The function itself is available for everyday calculation work
You also need more cloud storage, templates, or broader office benefits	WPS Premium	Better suited to ongoing work that needs added services and benefits

WPS membership center: Subscribe now