70.2K

Verified Solution

Link Copied!

The question is to write the formula

In cell D2, write a formula, which can be copied down the column to cells D3:D8, to display the annual fee the respective company charges to use their credit card. (Bank of America and Slate charge an annual fee of $59.00, Discover charges an annual fee of $25.00, Fifth Third charges an annual fee of $29.00 and U.S. Bank charges an annual fee of $20.00. All other companies listed in the spreadsheet do not charge an annual fee. This formula requires several nested ifs. We will use pseudocode (a combination of English and Excel syntax) to map the logic of this IF function. IF(OR(Credit Card Company = Bank of America, Credit Card Company = Slate), annual fee is $59, IF(Credit Card Company = Discover, annual fee is $25, IF(Credit Card Company = Fifth Third, annual fee is $29, IF(Credit Card Company = U.S. Bank, $20, otherwise annual fee is $0.00)))) Take the above pseudocode and translate it to Excel syntax. Not a Annual Fee Acceptable Credit Limit? Visa Card? No Introductory Rate of 0%? Credit Card 2 Capital One Venture B Bank of America 1 Fifth Third 5 Discover Slate 7 U.S. Bank 3 Simmons First Type Visa Visa Mastercard Discover Visa Mastercard Visa Credit Limit $5,000 $9,000 $2,500 $4,000 $6,000 $2,000 $4,500 Lowest Highest Introductory Credit Card Limit Acceptable Lowest APR APR Rate of 0% >$5000? APR? APR? 11.90% 19.90% TRUE 13.74% 22.74% TRUE 7.00% 21.99% FALSE 10.99% 22.90% FALSE 10.99% 18.99% FALSE 11.99% 21.99% TRUE 10.99% 20.99% FALSE o All Cards have an Introductory Rate of 0% (T/F)? 1 At least one Card has an Introductory Rate of 0% (T/F)

Answer & Explanation Solved by verified expert

See Answer