1. Home
  2. Computing & Technology
  3. Spreadsheets

Boolean Value

By , About.com Guide

Definition:

In computer science, Boolean data has two main values: TRUE or FALSE.

Sometimes, Boolean values are represented by the numbers " 1 " and " 0 ", with TRUE equaling 1 and FALSE equaling 0.

In Excel, Boolean values are used by the program's Logic Functions, such as IF, AND, and OR.

For example, the IF function evaluates a mathematical statement to see if it is TRUE or FALSE.

If a TRUE value is returned, the function will perform one action.

If a FALSE value is returned, the function will perform a different action.

Alternate Spellings: boolean
Explore Spreadsheets
About.com Special Features

The Best Web Trends of the Decade

A look back at the best innovations, ideas and technologies over the last 10 years, More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Spreadsheet Definitions
  5. B
  6. Spreadsheet Terms - Spreadsheet Definitions - Boolean Value

©2010 About.com, a part of The New York Times Company.

All rights reserved.