Shared Flashcard Set

Details

Logical spreadsheet functions
Logical spreadsheet functions in the NSS ICT curriculum.
4
Computer Science
10th Grade
12/08/2012
Click here to study/print these flashcards.

Create your own flash cards! Sign up here.

Additional Computer Science Flashcards

 

 

Cards

Term
IF({condition}, {value if true}, {value if false})
 Definition
Return one value if a condition is true and another value if a condition is false.
Term
AND({condition 1}, {condition 2} ... {condition n})
 Definition
Return TRUE if all the conditions are true; return FALSE if even on of the conditions is false.
Term
OR({condition 1}, {condition 2}, {condition 3})
[Inclusive]
 Definition
Return TRUE if any condition is true.
Term
NOT({condition})
 Definition
Return TRUE of the condition is FALSE and vice versa.
Supporting users have an ad free experience!