Excel formulas are expressions used to perform computation.
The Excel formula to enter in cell B13 is =IF(B9 < 600, "Denied","Approved)
From the question, we have:
- Cell B13 represents the applicant's eligibility status
- Cell B9 represents the credit score
The eligibility criteria are given as:
- Credit Score < 600 = “Denied”
- Credit Score >= 600 = “Approved”
To write the formula, we make use of an IF function
An IF function in Microsoft Office Excel has the following syntax
=IF([condition],[value if true],[value if false]).
So, the required formula to enter in cell B13 is:
=IF(B9 < 600, "Denied","Approved)
Read more about Excel formulas at:
brainly.com/question/25683602
