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.7
Overall Rating
82%
11%
4%
3%
0%
Reviews
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
S
sadananda basak
5
Teaching technique is easy to understand. Thanks.
J
Joydeep
5
nice
U
Uttam Nandi
5
Very nice teaching.
R
RABIN DEY
5
REALLY HELPFUL COURSE
S
Subhasis Bosu
5
good
A
Anamul Huq
5
This is helpful how are zero to intermediate level.
Share a personalized message with your friends.