If function nested calculation formula usage-excel-php.cn

If function nested calculation formula usage

angryTom

Release： 2020-03-07 16:05:53

Original

17251 people have browsed it

If function nested calculation formula usage

if function nested calculation formula usage

The IF function allows you to test a certain condition and return a True or False result to determine a certain condition. A logical comparison is made between the value and the expected value.

=IF（内容为 True，则执行某些操作，否则就执行其他操作）

Copy after login

So the IF statement may have two results. The first result is a comparison that evaluates to True, and the second result is a comparison that evaluates to False.

Recommended Learning: Excel Basic Tutorial

Ideally, the IF statement should be suitable for minimal conditions (such as Male/Female and Yes/No/Maybe), but for When evaluating more complex situations, you need to nest * more than 3 IF functions at the same time.

* "Nesting" refers to the practice of connecting multiple functions in a formula.

Let’s learn how to correctly create a complex nested IF statement using multiple IFs

##The following example describes a relatively standard nested IF statement that converts student test scores into equivalent letter grades.

=IF(D2>89,"A",IF(D2>79,"B",IF(D2>69,"C",IF(D2>59,"D","F"))))

Copy after login

This complex nested IF statement follows a simple logic:

1. If the Test Score (cell D2) is greater than 89, the student gets an A

2. If the Test If the Score is greater than 79, the student will receive a B

3. If the Test Score is greater than 69, the student will receive a C

4. If the Test Score is greater than 59, the student will receive a D

5. Otherwise , students get F

Note: It is not recommended to use multiple IFs, you can use the VLOOKUP function instead.

For more Excel tutorials, please pay attention to

PHP Chinese website!

The above is the detailed content of If function nested calculation formula usage. For more information, please follow other related articles on the PHP Chinese website!