# A collection helps you learn all basic excel formulas in WPS Office

A free Office suite fully compatible with Microsoft Office

### Catalog

###
Welcome to WPS Official Academy to check the contents of how to learn basic excel formulas in WPS Office.You are sure to master all basic excel formulas after reading this tutorial!

##
· **The basic excel formula about the SUM function**

The SUM function is commonly used when we process data with WPS Spreadsheet. Do you know how to sum the values with an basic excel formula in certain cells?

To learn how to input the basic excel formula, click to watch the video tutorial: Use SUM function to quickly calculate the sum.

##
· **The basic excel formula about t****he AVERAGE, MAXIMUM, MINIMUM functions**

When we analyze the sales performance of staff, the **AVERAGE**, **MAXIMUM**, and** MINIMUM** functions can help a lot.

To get the average values, we can use the **AVERAGE** function.

To know the maximumvalues, we can use the **MAX** function.

To know the minimumvalues, we can use the **MIN** function.

To learn how to input these basic excel formulas, click to watch the video tutorial: The AVERAGE, MAXIMUM, MINIMUM functions.

##
· **The basic excel formula about the RANK function**

RANK function is a statistical function that can quickly calculate the rank of a number in a list of numbers.

To learn how to input the basic excel formula, click to watch the video tutorial: How can we use RANK function.

##
· **The basic excel formula about the IF function**

The IF function can judge the specified condition and give two results when the condition is established and when it is not.

To learn how to input the basic excel formula, click to watch the video tutorial: Use IF function to judge data.

When judging multiple conditions, lengthy IF function will make it difficult for others to understand the logic when editing. Here, IFS function can be put to good use.

To learn how to input the basic excel formula, click to watch the video tutorial: Use IFS function to check whether multiple conditions are met.

##
· **The basic excel formula about the COUNT function**

When we do data statistics, we can use the COUNT function to count the number of cells containing values.

To learn how to input the basic excel formula, click to watch the video tutorial: Use COUNT function to count the number of cells with parameters.

### With these tutorials, you are able to learn basic excel formulas quickly and freely.

Did you get it?

Using WPS Office to create, edit and share Word, PPT, Excel and PDF. WPS Office Academy covers each step by giving free tutorials with details. Step by step, an office beginner becomes a pro. Versions are available for PCs including Mac, Windows, Linux, etc. Mobile versions include iOS and Android.

Also Read:

- 1. How to get month name from a date in Excel (3 easy ways)
- 2. Check if value is in list in Excel (3 easy methods)
- 3. How to Copy File Names in Excel from a Folder?
- 4. How to add text to beginning or end of all cells in Excel
- 5. How to color cell based on value in Excel?
- 6. How to compare two excel sheets and highlight differences