The question:

In cell I2, write a formula which can be copied down the column to cells I3:I8, to determine (T/F) if the card

has an acceptable APR. An acceptable APR is one that is between 11% and 20% or one that has an Annual Fee

of $0.00. Note: Please use the "Highest APR" value for this calculation.

Because we are checking more than one thing we will need to use a Boolean function.

Here we are asking: Is the Credit Card between 11%-20% OR does it have an annual fee of $0.00.

The basic syntax will be: = OR(AND( ____ >= ____, ____

You plug in the arguments.

A B D E F G H L M Acceptable Not a Credit Limit? Visa Card? No Introductory Rate of 0%? Credit Annual 1 Credit Card Type Limit Fee 2 Capital One Venture Visa $5,000 3 Bank Of America Visa $9,000 4 Fifth Third Mastercard $2,500 5 Discover Discover $4,000 6 Slate Visa $6,000 7 U.S. Bank Mastercard 8 Simmons First Visa $4,500 9 10 All Cards have an Introductory Rate of 0% (T/F)? 11 At least one Card has an Introductory Rate of 0% (T/F)? 12 0 59 29 25 59 20 Lowest Highest Introductory Credit Card Limit Acceptable Lowest APR APR Rate of 0% >$5000? APR? APR? 11.90% 19.90% TRUE FALSE 13.74% 22.74% TRUE TRUE 7.00% 21.99% FALSE FALSE 10.99% 22.90% FALSE FALSE 10.99% 18.99% FALSE TRUE 11.99% 21.99% TRUE FALSE 10.99% 20.99% FALSE FALSE $2,000 0