AMORDEGRC in WPS on Windows: Introduction

AMORDEGRC is a built-in financial depreciation function in WPS Spreadsheets for Windows; 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 How-to Index
Membership-related items	0	Matches the number of membership-related rows in the How-to Index

About This Feature

Overview

AMORDEGRC is a built-in function in WPS Spreadsheets that can be used for financial modeling, fixed-asset depreciation estimates, and accounting-period depreciation analysis. When you type the function name, the editor shows syntax guidance so you can check the parameter order and input format more easily.

Common ways to use this function include:

typing =AMORDEGRC( in a cell and reviewing the syntax prompt;
entering the required arguments and returning a depreciation result;
using cell references as function arguments;
recalculating results automatically after source data changes.

System Requirements

Item	Requirement
Operating system	A Windows device that can run WPS Office normally
App version	It is recommended to use the latest version of WPS Office
Network	Local function calculation does not require a constant internet connection; download, installation, and account actions require network access
Other	You need to open WPS Spreadsheets and edit worksheet cells

Download & Installation

Item	Details
Official download	WPS Office Free Download
Check after installation	Launch WPS Spreadsheets, open any worksheet, and type `=AMORDEGRC(` in a cell to confirm that the function prompt appears

Source: WPS Download Center

Compare with Alternatives

Dimension	WPS	Microsoft	Google	Notion	Adobe
Capability Summary	AMORDEGRC can be entered directly in spreadsheet cells in WPS Spreadsheets, with syntax prompts, cell references, nested calculations, and automatic recalculation.	Word supports formulas in table cells and can update results when the document opens or when you update fields manually, but it is mainly designed for document-table calculations rather than a full spreadsheet formula environment.	Google Sheets supports formulas and functions in cells, shows a function help box during editing, and provides a large function library for spreadsheet calculations.	Notion formulas work with database properties, built-ins, and functions for calculated fields in databases rather than traditional spreadsheet cells.	Acrobat supports calculated PDF form fields and form-based calculations, which fit document forms rather than spreadsheet-style worksheet modeling.
WPS Advantages	Advantage: WPS keeps formula entry, cell references, and recalculation in a spreadsheet workflow that fits continuous data analysis and financial worksheets.	Compared with WPS: Microsoft Word focuses more on formulas inside document tables, so large-scale worksheet-style formula editing is not its main scenario.	Compared with WPS: Google Sheets is strong for browser-based collaboration, while WPS fits desktop spreadsheet editing inside an office suite workflow.	Compared with WPS: Notion is more suitable for database-property logic, while WPS is more direct for cell-level formulas and worksheet calculations.	Compared with WPS: Acrobat is more suitable for PDF form calculations, while WPS is more suitable for worksheet-based function modeling and linked data updates.
Official Source	—	Use a formula in a Word table	Add formulas & functions	Intro to formulas	Advanced form fields

Overall Conclusion: For depreciation calculations, parameter references, and linked worksheet results, WPS provides a direct spreadsheet workflow. Other products are better aligned with document tables, online database logic, or PDF form calculations, depending on the work scenario.

Use Cases

No.	Scenario	Suitable for	Core need	How it helps
1	Fixed-asset depreciation estimates	Finance staff	Calculate depreciation by accounting period	Use AMORDEGRC to return depreciation results from the required arguments
2	Depreciation model building	Auditors and analysts	Reuse depreciation formulas in worksheets	Put arguments in cells and reference them in the function
3	Multi-sheet linked calculations	Business analysts	Keep results updated after data changes	Use automatic recalculation to reduce manual edits
4	Training and practice	Students and trainees	Learn the function format quickly	Use syntax prompts to verify arguments while practicing
5	Reusable finance templates	Office users	Avoid repeated formula entry	Preset the function in templates and reuse it

Membership & Benefits

Free vs WPS Premium

Capability	Free	WPS Premium
AMORDEGRC function entry and calculation	✅ Available	✅ Available
Basic spreadsheet editing	✅ Available	✅ Available
Cloud storage	1 GB	20 GB
Template downloads	Limited	More available
PDF tools and additional advanced features	Basic access	More features available

Source: WPS Office pricing page

Recommendations

Scenario	Recommended plan	Why
Daily function learning and basic depreciation calculations	Free	It already supports AMORDEGRC entry, calculation, and standard spreadsheet editing
Need more cloud storage and broader office features	WPS Premium	Suitable for users who also need more templates, cloud storage, and additional tools

WPS membership center: Subscribe now