Flashcards
Conditional Functions
Cards in this deck (3)
- 1What is a CONDITIONAL FUNCTION?Will only perform the calculation IF certain criteria are met.
- 2IF Function elementsCondition: Specifies rules to be checked (B1= "Beijing)
True Value: Specifies what to display if conditions ARE met ("well done")
False: Specifies what to display if the conditions are NOT met.
(Incorrect) - 3NESTED IFWhen more that 1 IF is used in the formula.
Useful if there are 2+ alternative outputs.
Information
- Description
- Information Technology (Spreadsheets) Flashcards on Conditional Functions, created by Ciarra jeffries on 06/01/2017.
- Created by
- Ciarra jeffries
- Views
- 0
- Rating