IF Functions

# IF Functions - argument I consider the value_if_true...

This preview shows pages 1–7. Sign up to view the full content.

Click to edit Master subtitle style Introduction to the   IF Function Supplement to Chapter 3, Part 2 Class  Notes

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
What are logical  Two values are compared, using a logical  operator:   = >, >= <, <= <> Examples?
Simple logic v. compound logic: Simple logic involves only one comparison. Example: IF department = "Sales", then … Compound logic involves multiple  comparisons.   Examples: If department = "Sales"  OR  department = "Finance", then… If department = "Sales"  AND  salary > \$50,000, then…

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
"Logical" functions A category of Excel functions Used to return a value based on the outcome  of: one logical comparison   OR a group of logical comparisons.   Some logical functions in Excel IF AND
The IF Function IF(logical_test, value_if_true, [value_if_false]) There is a slight difference between Excel and  textbook (p. 87) treatment of the second

This preview has intentionally blurred sections. Sign up to view the full version.

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

Unformatted text preview: argument. I consider the value_if_true argument to be required, but Excel puts brackets around it which denotes it as optional. If the argument is truly optional, then the comma should NOT be required following the first argument, but it is required (at Arguments of the IF Function logical_test the IF part, the logical comparison value_if_true what is returned if the logical comparison is evaluated to TRUE [value_if_false] what is returned if the logical comparison is evaluated to FALSE Function Practice In the FunctionsPractice.xlsx workbook, enter a formula into the “Vested” column that will return “Yes” if the employee has been employed enough years to be vested and “No” if he has not. Use the TODAY() function to calculate the duration of employment....
View Full Document

{[ snackBarMessage ]}

### Page1 / 7

IF Functions - argument I consider the value_if_true...

This preview shows document pages 1 - 7. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online