Flashcards
Conditional Functions
Flashcards do conjunto (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.
Informações
- Descrição
- Information Technology (Spreadsheets) FlashCards sobre Conditional Functions, criado por Ciarra jeffries em 06-01-2017.
- Criado por
- Ciarra jeffries
- Visualizações
- 0
- Avaliação