In this article, we will learn about how to use nested IF function in excel 2016.
IF function is used for logic_test and returns value on the basis of the result of the logic_test.
Let’s understand this function using it an example.
We need to find the Grade for the corresponding Scores.
Use the Formula
The flow chart above explains the nested IF logic.
Applying the formula in other cells using CTRL + D.
As you can see it’s easy to get the Grades having multiple conditions.
Hope you understood how to work with nested IF function in Excel. Explore more articles on Excel logic_test functions here. Please feel free to state your queries or feedback about the article in the comment box below.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.