Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
5 Cards in this Set
- Front
- Back
IF |
= IF (Logical test , if true, if false)
=IF(x>19,"true","ignore") |
|
NESTED FUNCTIONS |
IF the condition is true,false, we can provide other options via NESTED functins
eg - if sales greater 1000, there is a bonus of 50. If not other criteria apply.
IF (X>1000,50,IF(x>800,20,""))
more nested
IF (X>1000,50,IF(x>800,20,IF(x>500,10,0))) |
|
COMPOUND - IF & AND |
Multiple criteria must be met eg sales > 1000 and employer = full time and job review >2
IF ( AND (x > 1000,Y = FT, z >2),100,0)
* AND = includes the criteria true = 100 false = 0 |
|
COMPOUND - IF & OR |
= IF ( OR (List the numerous conditions, a , b, c,), true, flast) |
|
formula for IF function including both OR & AND |
=IF ( OR (z = 2, n >50, (AND (x=5,y>100))) , TRUE condition , FALSE condition ) |