Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You need to provide a rate for each customer based on their credit score. Any user who has a score less than 6 0 0

You need to provide a rate for each customer based on their credit score. Any user who has a score less than 600 should be denied 1. Open case_study1_data and save as case_study1_LastFirst (use your own Last and First name). IF Function- Use the IF Function to figure out N an applicant is eligible for a personal loan. Please review this tutorial: Excel IF Functions For Becinners for help. 2. Display the Approval Form worksheet and create an IF statement in cell 13 to determine if the applicant is eligible for a personal loan. Use the criteria below as part of your logic statement: Credit Score <600= "Denied" Credit Score >=600= "Approved

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Online Market Research Cost Effective Searching Of The Internet And Online Databases

Authors: John F. Lescher

1st Edition

0201489295, 978-0201489293

More Books

Students also viewed these Databases questions

Question

7. Understand the challenges of multilingualism.

Answered: 1 week ago