The AND Function in WPS Spreadsheet

Combine the SUBSTITUTE and LEN functions

INDEX MATCH formulas

Use IFS function to check whether multiple conditions are met

The INDEX function

Use MATCH function to search location information

The AVERAGE, MAXIMUM, MINIMUM functions

Use the text function to extract characters in cells

Elementary arithmetic functions in WPS Spreadsheet

Efficient statistics with statistical functions

Create a countdown calendar & Insert current time and date

Use COUNTIF function for conditional statistics

Use SUM function to quickly calculate the sum

Use IF function to judge data

SUBTOTAL function: Calculate the data with the hidden value

How to use the MID function in WPS Spreadsheet