IF FORMULA/FUNCTION

It is IF FUNCTION may perform a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" Total Marks >300: =IF(G4>300,"Pass","Fail") More than one condition can be tested by nesting IF functions. The IF function can be collective with logical functions like AND and OR.

Note 1. :- If function working for a specific condition that mean it values you supply for TRUE or FALSE.

Note 2. :- It is use to IF FUNCTION to test for or evaluate certain conditions, and then react differently depending on whether the test was TRUE or FALSE.

Syntax :- =IF (logical_test, {value_if_true}, {value_if_false}) Enter

Example Step:-

Step 1.) logical_test - A value or logical expression that can be evaluated as TRUE or FALSE.

Step 2.) value_if_true – {optional} The value to return when logical_test evaluates to TRUE.

Step 3.) value_if_false – {optional} The value to return when logical_test evaluates to FALSE.

Example :-  =IF(G4>300,"Pass","Fail") Enter

Information  :- In This formula we have wrong write word of (Fail ) below screen shot please correct self  Thank you

👉Nested IF statements/Example more powerful formula.

It is use to IF FUNCTION could be "nested". A "nested IF" refers to a formula where at least one IF function is nested inside another in order to test for more conditions and return more possible results. Each IF testimonial needs to be carefully "nested" inside another so that the logic is correct.

Logical operators example for if condition

When you are constructing a test with IF, you can use any of the following logical operators:

 

Comparison operator    Meaning                                             Example

=                                      equal to                                               D1=E1

>                                      greater than                                       D1>E1

>=                                    greater than or equal to                   D1>=E1

<                                      less than                                             D1

<=                                    less than or equal to                         D1<=E1

<>                                    not equal to                                       D1<>E1

Example for Nested IF FORMULA

=IF(L4>80%,"Excellent",IF(L4>=60%,"First",IF(L4>=50%,"Second",IF(L4>=30%,"Third","Fail")))) ENTER