Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets
photo of Ted French

Ted's Spreadsheets Blog

By Ted French, About.com Guide to Spreadsheets

Excel 2007 OR Function

Monday March 23, 2009
The OR function is one of Excel's Logical Functions. What a logical function does is evaluate the data in a certain cell to see if it meets specified criteria. If it does, the function returns a True response in the cell where the function is located. If not, a False statement is returned.

In Excel 2007, the OR function allows you to specify up to 255 criteria to be evaluated. If any of these criteria meet the specified criteria the function returns a True response.

By itself, the OR function has limited usefulness, but, by combining it with another function, such as the IF function, the OR function can greatly increase the capabilities of your spreadsheet.

To find out how to use this function, read this short article on the Excel 2007 OR Function.

Related Articles

Comments

No comments yet. Leave a Comment

Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

Discuss

Community Forum

Explore Spreadsheets

About.com Special Features

Spreadsheets

  1. Home
  2. Computing & Technology
  3. Spreadsheets

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

All rights reserved.