In this video I have explain in detailed about Excel Logical Function #NESTED_IF. When IF function nested inside of itself to handle multiple conditions, become Nested #IF Function. If need to test more than one condition, then we use IF function that will depend on the result of the test, one option is to nest multiple IF statements together in one formula. This is the one of the best function of Excel That help us to get the desired result based on our choice. The Basic of IF Function rule =IF