1. Technology
You can opt-out at any time. Please refer to our privacy policy for contact information.

Logical Value

By

Using Logical Values in Calculations

Using Logical Values in Calculations

© Ted French
Definition:

A "Logical Value", also known as a "Boolean Value": has only two values in Excel: TRUE and FALSE.

The use of Logical values in Excel is most often associated with the Logical group of function such as the IF function, the AND function, and the OR function.

In these functions, logical values can be input as one of the function's arguments or they can form the output of a function that is evaluating other data in the worksheet.

Logical Values and Calculations

Logical values can also, in certain circumstances, be used in calculations.

When this occurs, Excel considers the logical values to be numbers,

TRUE is taken to have a value of one "1" and FALSE has a value of zero "0".

An example of using logical values in calculations can be seen in the image above where the logical values in cells F1 to F4 are added together in the formula:

   = F1 + F2 + F3 + F4

Since TRUE is equal to 1 and FALSE equal to 0, the answer to the formula is 2.

   = 1 + 0 + 1 + 0

Logical Values and Excel's Functions

Many of Excel's functions, such as the SUM function, the MAX function and the MIN function, ignore logical values.

As a result, the SUM function in the image above returns an answer of zero since it considers cells F1 to F4 to be blank.

To use logical values in functions such as SUM, the logical values must first be converted to numbers.

Also Known As: Boolean Value

©2014 About.com. All rights reserved.