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.
Learner's Ratings
4.6
Overall Rating
81%
11%
5%
3%
0%
Reviews
S
Srijib Bhadra
5
MS Excel is a very important course, and it has helped me a lot in many ways
S
Sakibul Hasan Akash
5
"The teacher's presentation was very clear and well-organized. He tried to explain everything one by one. The teacher explained the topic very well and presented all the important points in a simple
S
Sayeed Arshif
5
Best
S
SUSANTA BARMAN
4
best website...thanks for this, but, If there was a system to share Excel files along with the video, it would be convenient to practice while watching the video
P
Prabhat Yadav
5
Superb and amazing 😍🤩 enjoyable experience.
P
pritam chakraborty
5
very good
S
Sudip Sadhukhan
5
Very good teaching technique. And it is totally free so who has only want to learn free so it is so much useful for them. Thank you
Share a personalized message with your friends.