Simple IF Function (Grade 11 NSC Matric Computer Application Technology): Flashcards
📚Flashcards
Practise the cards
10 cards from this deck
ShowHide
Practise the cards
10 cards from this deck
Type of Excel function that IF belongs to
Type of Excel function that IF belongs to
Logical function
Basic syntax structure of IF function
Basic syntax structure of IF function
IF(condition, value_if_true, value_if_false)
What the 'condition' part of IF function checks
What the 'condition' part of IF function checks
The question Excel checks/evaluates
What 'value_if_true' displays in IF function
What 'value_if_true' displays in IF function
What Excel shows when condition is true/correct
What 'value_if_false' displays in IF function
What 'value_if_false' displays in IF function
What Excel shows when condition is false/incorrect
How text values must be formatted in IF functions
How text values must be formatted in IF functions
Enclosed in quotation marks
Number formatting requirement in IF functions
Number formatting requirement in IF functions
No quotes needed
Excel's case-sensitivity with text in IF
Excel's case-sensitivity with text in IF
Case-sensitive (Rain ≠ rain)
What Excel evaluates first in IF function
What Excel evaluates first in IF function
The condition
Use of cell references in IF functions
Use of cell references in IF functions
Can be used in any part to make it dynamic