WPS Spreadsheet — Function Directory
Browse 54 published, source-reviewed guides with syntax, reproducible examples and troubleshooting. This is not a complete inventory of all functions supported by WPS Spreadsheet.
54 functions
Browse by category
A
- ABSLearn the ABS formula in WPS Spreadsheet: get a nonnegative magnitude without changing absolute size, with reproducible …
- ANDLearn the AND formula in WPS Spreadsheet: require several conditions to be true, with reproducible examples, expected answers …
- AVERAGELearn the AVERAGE formula in WPS Spreadsheet: calculate the arithmetic mean of numeric cells, with reproducible examples, …
- AVERAGEIFLearn the AVERAGEIF formula in WPS Spreadsheet: average numbers matching a single condition, with reproducible examples, …
C
- CHOOSEUse CHOOSE in WPS Spreadsheet to select one of several values by its 1-based index. Two original examples, expected results, …
- COUNTLearn the COUNT formula in WPS Spreadsheet: count numeric cells without counting text, with reproducible examples, expected …
- COUNTALearn the COUNTA formula in WPS Spreadsheet: count cells containing values including text, with reproducible examples, …
- COUNTIFLearn the COUNTIF formula in WPS Spreadsheet: count records matching one criterion, with reproducible examples, expected …
- COUNTIFSLearn the COUNTIFS formula in WPS Spreadsheet: count rows meeting multiple aligned conditions, with reproducible examples, …
D
- DATELearn the DATE formula in WPS Spreadsheet: build a real date from numeric components, with reproducible examples, expected …
- DATEDIFUse DATEDIF in WPS Spreadsheet to measure completed years or days between two dates without counting partial anniversaries as …
- DAYLearn the DAY formula in WPS Spreadsheet: extract the day of month from a date, with reproducible examples, expected answers …
H
I
- IFLearn the IF formula in WPS Spreadsheet: choose between two outcomes using a logical test, with reproducible examples, …
- IFERRORLearn the IFERROR formula in WPS Spreadsheet: replace a formula error with a chosen fallback, with reproducible examples, …
- IFSUse IFS in WPS Spreadsheet to return the first matching outcome from several ordered conditions. Two original examples, …
- INDEXLearn the INDEX formula in WPS Spreadsheet: return the value at a position inside a range, with reproducible examples, …
- INDIRECTUse INDIRECT in WPS Spreadsheet to turn a text address into a live cell reference. Two original examples, expected results, …
- ISNUMBERLearn the ISNUMBER formula in WPS Spreadsheet: determine whether a value is numerical, with reproducible examples, expected …
L
- LARGEUse LARGE in WPS Spreadsheet with three worked numeric examples, CSV practice data, tie rules, and software-specific …
- LEFTLearn the LEFT formula in WPS Spreadsheet: extract a set number of characters from the start of text, with reproducible …
- LENLearn the LEN formula in WPS Spreadsheet: measure the number of characters in a text string, with reproducible examples, …
- LOOKUPUse LOOKUP in WPS Spreadsheet to find an approximate match in a sorted key column and return a corresponding category. Two …
M
- MATCHLearn the MATCH formula in WPS Spreadsheet: find the relative position of a matching key, with reproducible examples, …
- MODLearn the MOD formula in WPS Spreadsheet: return the remainder with the divisor sign convention, with reproducible examples, …
- MONTHLearn the MONTH formula in WPS Spreadsheet: extract the month number from a date, with reproducible examples, expected …
N
- NETWORKDAYSUse NETWORKDAYS in WPS Spreadsheet to count workdays in a date interval without manually excluding weekends. Two original …
- NOTLearn the NOT formula in WPS Spreadsheet: reverse a TRUE or FALSE result, with reproducible examples, expected answers and …
- NOWUse NOW in WPS Spreadsheet to return a live date-and-time value, useful for elapsed-time monitoring. Two original examples, …
O
R
- RIGHTLearn the RIGHT formula in WPS Spreadsheet: extract characters from the end of a text value, with reproducible examples, …
- ROUNDLearn the ROUND formula in WPS Spreadsheet: round to the specified decimal place, with reproducible examples, expected …
- ROUNDDOWNLearn the ROUNDDOWN formula in WPS Spreadsheet: round toward zero at a specified precision, with reproducible examples, …
- ROUNDUPLearn the ROUNDUP formula in WPS Spreadsheet: round a number away from zero to a chosen precision, with reproducible …
S
- SMALLUse SMALL in WPS Spreadsheet with three worked numeric examples, CSV practice data, tie rules, and software-specific …
- STDEV.PUse STDEV.P in WPS Spreadsheet with three worked numeric examples, CSV practice data, interpretation checks, and …
- STDEV.SUse STDEV.S in WPS Spreadsheet with three worked numeric examples, CSV practice data, interpretation checks, and …
- SUBTOTALUse SUBTOTAL in WPS Spreadsheet to summarize a filtered list while controlling treatment of hidden rows. Two original …
- SUMLearn the SUM formula in WPS Spreadsheet: add a group of numeric values, with reproducible examples, expected answers and …
- SUMIFLearn the SUMIF formula in WPS Spreadsheet: sum matching values using one condition, with reproducible examples, expected …
- SUMIFSLearn the SUMIFS formula in WPS Spreadsheet: sum values when multiple conditions all hold, with reproducible examples, …
- SUMPRODUCTLearn the SUMPRODUCT formula in WPS Spreadsheet: multiply aligned values row by row and sum the results, with reproducible …
T
- TEXTUse TEXT in WPS Spreadsheet to produce a formatted text label from a number without changing the original numeric cell. Two …
- TODAYUse TODAY in WPS Spreadsheet to insert the current calendar date without typing it again. Two original examples, expected …
- TRANSPOSEUse TRANSPOSE in WPS Spreadsheet to rotate a rectangular dataset so rows become columns and columns become rows. Two original …
- TRIMLearn the TRIM formula in WPS Spreadsheet: remove unwanted ordinary spaces from a text string, with reproducible examples, …
V
W
- WEEKDAYUse WEEKDAY in WPS Spreadsheet to convert a date into a weekday number to drive scheduling rules. Two original examples, …
- WEEKNUMUse WEEKNUM in WPS Spreadsheet to calculate a calendar week number for reports without confusing it with ISO week numbering. …
- WORKDAYUse WORKDAY in WPS Spreadsheet to find a due date a set number of working days after an initial date. Two original examples, …
X
Y
No functions match your filters. Try a different name or category.