Question: 2 . Display the Approval Form worksheet and create an IF statement in cell I 3 to determine if the applicant is eligible for a

2. Display the Approval Form worksheet and create an IF statement in cell I3 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
3. Copy using the Fill Handle the IF statement in cell I3 to into the Range I4:I10.
VLOOKUP Function Use the VLOOKUP Function to determine the rate of for those

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!