Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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 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)Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started