Need Help? Chat with us

IF function and Nested IF function in Excel

IF Function:-
The IF function is one of the most popular functions in Excel, and it allows you to make logical comparisons between a value and what you expect. In its simplest form, the IF function says:



Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

IF(Something is True, then do something, otherwise do something else)






So an IF statement can have two results. The first result is if your comparison is True, the second if your comparison is False

Nested IF Function:-
Using a function as one of the arguments in a formula that uses a function is called nesting, and we’ll refer to that function as a nested function.

Learn 100+ Excel Tips & Tricks



“To be an Excel Superstar”

Special Offer for First Time Users

If you are the first time user and want to learn Microsoft office skills, then you can avail this special offer discount on your email.

PIvot table Webinar payment Code

Download ebook