Course Content

Course Content


The IF function performs a logical test and returns two values: one for TRUE and another for FALSE. =IF(A1>70,"Pass","Fail"), for example, to "pass" scores above 70. IF functions can be nested to test several conditions.

Excel's IF Function In Excel, the IF function makes a logical comparison between two values. The IF function returns either TRUE or FALSE as a result. We can, for instance, see if the value in cell B2 is higher than the value in cell A2. If this is the case, the result is TRUE; otherwise, the result is FALSE.

The IF statement checks an expression to see if it meets a condition and then returns a value based on the result. For example, if the condition is found to be true, it returns one predetermined value; if the statement is found to be false, it returns a different prepared value.

The if statement is used to check a condition, and if the condition is true, a block of statements (called the if-block) is executed; otherwise, another block of statements is executed (called the else-block). The else clause is not required.

Syntax. If a condition is true, the IF function returns one value; if it is false, it returns another one. =IF(A2>B2,"Over Budget","OK"), for example.

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
Apple App Store
598K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
15K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere