2010 9 using the if function new perspectives on

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: false Syntax: New Perspectives on Microsoft Excel 2010 9 Using the IF Function New Perspectives on Microsoft Excel 2010 XP XP 10 Using the IF Function New Perspectives on Microsoft Excel 2010 XP XP 11 Using the AND Function • • • XP XP A logical function that tests two or more conditions (up to 255) and determines whether all conditions are true Returns the value TRUE if all logical conditions are true and the value FALSE if any or all logical conditions are false Syntax: New Perspectives on Microsoft Excel 2010 12 Using the AND Function New Perspectives on Microsoft Excel 2010 XP XP 13 Using the AND Function New Perspectives on Microsoft Excel 2010 XP XP 14 Using the AND Function New Perspectives on Microsoft Excel 2010 XP XP 15 Using the OR Function • • XP XP A logical function that returns a TRUE value if any of the logical conditions (up to 255) are true and a FALSE value if all the logical conditions are false Syntax: New Perspectives on Microsoft Excel 2010 16 Using the OR Function New Perspectives on Microsoft Excel 2010 XP XP 17 Using Structured References to XP XP Create Formulas in Excel Tables • • Replace specific cell or range address with the actual table name or column header – Names or headers are simpler to identify than cell addresses A formula that includes a structured reference can be fully qualified or unqualified New Perspectives on Microsoft Excel 2010 18 Using Structured References to XP XP Create Formulas in Excel Tables New Perspectives on Microsoft Excel 2010 19 Visual Overview New Perspectives on Microsoft Excel 2010 XP XP 20 XP X Nested IFs and Lookup TablesP New Perspectives on Microsoft Excel 2010 21 Creating Nested IFs • • • XP XP To allow for three or more outcomes One IF function is placed inside another IF function to test an additional condition More than one IF function can be nested New Perspectives on Microsoft Excel 2010 22 Creating Nested IFs New Perspectives on Microsoft Excel 2010 XP XP 23 Crea...
View Full Document

This document was uploaded on 02/24/2014.

Ask a homework question - tutors are online