Chapter 4 - Decision Logic Flashcards
What is the key to statements?
The expressions they contain
True or False:
Some condition must be true before the specified action may be taken
True
What is the format of the IF Formula?
IF(condition,true,false)
Which conditions are created when comparing variables with relational operators by evaluating a Boolean variable?
True or False conditions
What are created when conditions are evaluated?
Boolean variables
Fill in the Blanks:
The ___ statement is considered data expanding while the ___ is data reducing
- OR
2. AND
Which of the following is an example of how the NOT statement should be used in a function?
A. (NOT(T and F) or (T and F))
B. NOT( F or F )
C. Not(F)
D. All of the above
D. All of the above
What do you create when you join separate conditions with the ‘AND’ and the ‘OR’?
A compound condition
What is a compound condition’s order of evaluation?
Evaluate ANDs before ORs
Which type of statements handle more complex logic?
Nested IF statements
Give returning customers who have spent more than $1000, a 10% “loyalty discount.” If the customer is a returning customer, there is a 1 in the A column of the customer’s row. The amount owed is in B3.
What would this formula look like using the compound condition format?
=IF(AND(A1=1, B3>1000), b3.9, b31.00)
If Returning Customer (A1 = 1) AND
Spent more than $1000 (B3 > $1000) Then
provide discount (Multiply B3 by .90)
Else
provide no discount (Multiply B3 b 1.00)
End If
Give returning customers who have spent more than $1000, a 10% “loyalty discount.” If the customer is a returning customer, there is a 1 in the A column of the customer’s row. The amount owed is in B3.
What would this formula look like using the nested IF statement format?
=IF(A1=1, IF(B3>1000, b3.9, b31.00), b3*1.00)
If Returning Customer (A1 = 1) AND
If Spent more than $1000 (If B3 > $1000) Then
provide discount (Multiply B3 by .90)
Else
provide no discount (Multiply B3 b 1.00)
End If
Else
provide no discount (Multiply B3 b 1.00)
End If