Logical Functions in Excel

Logical functions allow you to determine whether a value is true or false depending on the contents of the selected cells. Specified criteria are set in the calculation to find out whether certain conditions are met or not. Logical functions are useful calculations that can be made to find out if certain criteria are met among a range of selected cells.

And, Or & Not

1. Create the following worksheet:

2. Select cell E3

3. On the Formulas tab in the Function Library select Logical

4. Select AND

5. Select cell D3

6. Click OK

7. The calculation is true so returns a value of True

Or Function

1. Enter in the following information:

2. Select cell E4

3. On the Formulas tab in the Function Library select Logical

4. Select OR

5. Select D3 for Logical1 and D4 for Logical2

6. Click OK

7. The value True appears because the calculations are correct

Not Function

1. Select cell E5

2. On the Formulas tab in the Function Library select Logical

3. Select Not

4. Select Cell E4

5. Click OK

6. A value of False was produced because the value True was not False

7. Save the workbook

For further information about Advanced Excel features click the link below: