Question: 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!