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

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

View Full Document Right Arrow Icon
Click to edit Master subtitle style Introduction to the   IF Function Supplement to Chapter 3, Part 2 Class  Notes
Background image of page 1

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

View Full DocumentRight Arrow Icon
What are logical  Two values are compared, using a logical  operator:   = >, >= <, <= <> Examples?
Background image of page 2
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…
Background image of page 3

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

View Full DocumentRight Arrow Icon
 "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
Background image of page 4
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 
Background image of page 5

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

View Full DocumentRight Arrow Icon
Background image of page 6
Background image of page 7
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

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 Right Arrow Icon
Ask a homework question - tutors are online