How to use Logical IF Function in Microsoft Excel in Easy Way

How to use Logical IF Function in Microsoft Excel in Easy Way [Full Tutorial]

Description:

In this tutorial, we will discuss How to use Logical IF Function in Microsoft Excel in Easy Way. The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result.  This flowchart shows how to work IF Conditional block work.

if function flow chat

How to use Logical IF Function in Microsoft Excel in Easy Way.

Syntax:

=IF(logical_test,value_if_true,value_if_false)

Logical_test: 

is any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any logical calculation operator.

Logical OperatorDescription
Equal Sign = Equal to
Greater Than Sign >Greater than
Less Than Sign <Less than
Greater Than or Equal to Sign >=Greater than or equal to
Less Than or Equal to Sign <= Less than or equal to
Not Equal to Sign <> Not equal to

How to use Logical IF Function in Microsoft Excel in Easy Way.

Value_if_true:

is the value that is returned if logical_test is TRUE. For example, if this argument is the text string “Within budget” and the logical_test argument evaluates to TRUE, then the IF function displays the text “Within budget”. If logical_test is TRUE and value_if_true is blank, this argument returns 0 (zero). To display the word TRUE, use the logical value TRUE for this argument. Value_if_true can be another formula.

Value_if_false:

is the value that is returned if logical_test is FALSE. For example, if this argument is the text string “Over budget” and the logical_test argument evaluates to FALSE, then the IF function displays the text “Over budget”. If logical_test is FALSE and value_if_false is omitted, (that is, after value_if_true, there is no comma), then the logical value FALSE is returned. If logical_test is FALSE and value_if_false is blank (that is, after value_if_true, there is a comma followed by the closing parenthesis), then the value 0 (zero) is returned. Value_if_false can be another formula.

Note: 

If alphabetical data (A-Z, a-z, Special Symbols) in use IF Function, then just use Equal Sign = and if use numerical data (0-9) then you can use all comparison operators like (=, >,< ,>=,<=,<>).

Examples 1:

IF Function Examples

=IF(C3>=65,”Pass”,”Fail”)

 

Nested Conditions:

Nested conditions work as follows: You can group multiple condition statements. 

Examples 2:

nested condition in if function

 

=IF(L7>=80,”A-1″,IF(L7>=70,”A”,IF(L7>=60,”B”,IF(L7>=50,”C”,IF(L7>=40,”D”,”Fail”)))))

Contact:

Any Kind Of Help Or Needs So Contact Me:
Facebook Group: [ https://www.facebook.com/Tutorials-Ocean-185506455425271/ ]

Leave a Reply

Your email address will not be published. Required fields are marked *