Hi!
Good day!
I am new to ExcelForum, appreciate your support throughout!
I need to get a formula to calculate the following:
Assuming
A1 has Loan Percentage values
B1 has year range values
C1 = result
The suggestion i have made is just a Logic (may contain errors)
:
If the loan percentage is below 80.01% (starting from 80% to 1%)
no calculation , need to write NA
Sugg:
(A1<=80 return "NA")
If the loan percentage is 80.01% to 85%
for 1 to 20 years 0.19%
for 21 to 30 years 0.32%
Sugg:
IF(A1>80 <=85 AND IF B1 >=1 <=20 RETURN C1=0.19)
OR IF
(A1>80 <=85 AND IF B1 >=21 <=30 RETURN C1=0.32)
If the loan percentage is 85.01% to 90%
for 1 to 20 years 0.23%
for 21 to 30 years 0.52%
Sugg:
IF(A1>85 <=90 AND IF B1 >=1 <=20 RETURN C1=0.23)
OR IF
(A1>85 <=90 AND IF B1 >=21 <=30 RETURN C1=0.52)
If the loan percentage is 90.01% to 95%
for 1 to 20 years 0.26%
for 21 to 30 years 0.78%
Sugg:
IF(A1>90 <=95 AND IF B1 >=1 <=20 RETURN C1=0.26)
OR IF
(A1>90 <=95 AND IF B1 >=21 <=30 RETURN C1=0.78)
If the loan percentage is 95.01% to 97%
for 1 to 20 years 0.79%
for 21 to 30 years 0.90%
Sugg:
IF (A1>95 <=97 AND IF B1 >=1 <=20 RETURN C1=0.79)
OR IF
(A1>95 <=97 AND IF B1 >=21 <=30 RETURN C1=0.90)
IF the loan percentage found with above 97.01% to 100%
no calculation , need to write NA
Sugg:
IF(A1>=97 <-100 RETURN "NA")
Appreciate your early response , thank you
Bookmarks