Excel 2010: Basic Logical Functions

Through using logical functions provided by Excel 2010, we could apply and evaluate specific rationale on the data. The most commonly used logical functions are AND, OR, and NOT. They take values as arguments to apply a simple logic on them. In this post we will be focusing only on AND & OR logical function.

Launch Excel 2010 spreadsheet on which you want to apply logical functions. For illustration we will be applying AND & OR logical functions in spreadsheet containing fields; Name, Course, Marks, Grade, and Status, as shown in the screen shot below.

Now we will be applying logical operations over different fields. If we want to find out that how many students studied HTML & Scripting course and scured 60+ marks, then we will be writing AND function. This function returns TRUE if both specified conditions or criteria met.

If student studied HTML & scripting and secured marks greater than 60, only then the condition is said to be TRUE.

The syntax of function is;

=AND(logical1, logical2…)

We will be writing it as;

=AND(C2=”HTMl & Scripting”,D2>60)

C2 and D2 in the function arguments are location of the cell from where we started searching. The output True can bee seen in the screenshot below only where both conditions have met. Conversely FALSE will appear where any of the condition is not met.

Now we are going to find out the row against either Marks less than 60 or Status is fail. For this we will write OR logical function as;

=OR(D2<59,E2=”D”)

Where D2 and E2 are the locations of the cells in Marks and Grade field respectively. As TRUE can be seen against all the values in either field Marks or Grade where marks are less than 60 or grade is D.

You can also check out previously reviewed Excel function; DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, and LEN.