How to use if function in excel2010

How to use excel2010 if function

First let’s look at the case to be operated, we need to calculate the To determine the sales ratio, then multiply the sales volume by the sales ratio to get the commission, as shown in the figure below

Recommended tutorial:excel tutorial

Next we use the IF function to calculate the sales ratio, as shown in the figure below. The IF function receives three parameters. The first is the judgment condition, the second is the return value when the condition is true, and the third is the condition. The return value when it is false is as shown in the figure below

#After entering the IF function formula, we can automatically calculate the sales ratio corresponding to the current cell by pressing the Enter key. , as shown in the picture below

#The next thing to do is to pull down the first cell, as shown in the picture below, each commission ratio has been determined

In addition, the IF function can return not only numerical values ​​but also text content, as shown in the figure below. Note that the returned text value uses English single quotes

Finally, pull down and you will get the note text content as shown below. How about it? Is it very fast and simple?

To sum up the above As mentioned above, the IF function used in Excel accepts three parameters, namely the judgment condition and the true or false return value. It must be noted that the return value must use absolute references.

The above is the detailed content of How to use if function in excel2010. For more information, please follow other related articles on the PHP Chinese website!