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，则执行某些操作，否则就执行其他操作）
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
=IF(D2>89,"A",IF(D2>79,"B",IF(D2>69,"C",IF(D2>59,"D","F"))))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!