Spreadsheets

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

Ted's Spreadsheets Blog

By Ted French, About.com Guide to Spreadsheets

Nested IF Functions in Excel

Wednesday October 1, 2008
Believe it or not some people shy away from using the IF function because of its apparent complexity. In doing so, they are missing out on one of the most useful functions available in spreadsheet programs like Excel.

Using the IF function adds flexibility to a spreadsheet by introducing decision making. What the IF function does is test to see if a certain condition is true or false. If it is true, the function enters one result in a specific cell. If the condition is false, it enters a different result into that cell.

To further increase the flexibility of your spreadsheets, it is possible to Nest or place one IF function inside another.

To find out how to do this, read the article on Nested IF Functions in Excel.

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.