MS-Excel (Logical Functions)

LOGICAL FUNCTIONS IN EXCEL

AND FUNCTION

This function is used to test one or more conditions and produce true when all the conditions would true otherwise it returns false.

EXAMPLE

=AND(I9="Purchase",H9>=15000)

OR FUNCTION

This function is used to test one or more conditions and produce true even only one condition would be true, produce false when all the conditions would be false.

EXAMPLE

=OR(B3>=30,C3>=35)

IF FUNCTION

This function is also known as condition maker because it used to implement one or more conditions. 

EXAMPLE 1: This example print "Pass" if marks>=33 and print fail if marks<33.

=IF(A1>=33,”Pass”,”Fail”)

GUI EXAMPLE

EXAMPLE 2: This example calculates tax 4% on salary when salary amount is greater than 15,000.

=IF(A1>15000,(A1*4/100),0)

CALCULATE GRADE BY IF FORMULA IN MS EXCEL

We can calculate grade by If function and to perform this task we have to use the nested if function.

Nested If: nested if consisted with multiple 'If' statement so in this statement one if statement defines in another if statement.

EXAMPLE
=IF(C2>=75,"A",IF(C2>=50,"B",IF(C2>=33,"C","F")))

Conditions With Output

HOME