Lesson#6: What is Function IF in Excel?

In this post, we will discuss function IF. IF is a logical function that checks whether a condition is met and then returns a value if TRUE or another value if FALSE. Syntax of function IF is =IF(logic_test, value_if true, value_if_false).

I have added a row to show a simple example of IF by showing the marks PASS or FAIL.

I need to check the condition of the marks is below 25 then It will write “FAIL”, else “PASS”. The structure is shown in the above picture.

In my next post, I will show how this function can be used in multiple layers to check multiple conditions and return values.

Related video tutorials: