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
Code Scan
or
Download the app
598K+
Downloads
4.57
Avg. Ratings
15K+
Reviews
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
Enjoying this course!
All the Courses on Learnvern are Free! So Register/Sign in to
have Access all the Courses and Videos.