Hi!
Please help me with an Excel Formula/Function to obtain the following result:
cell: A1 = 1st data (loan percentage)
cell: B1 = 2nd data (years)
cell: C1 = 3rd data (Result)
1. If A1 = 85 (exact 85 only)
and if B1= < 25
then c1 = 0.21
or if B1= >25 and <= 30 years
then c1 = 0.32
2. If A1 >=1 and < 85
and if B1= < 25
then c1 = 0.32
or if B1= >25 and <= 30 years
then c1 = 0.32
3. If A1 >85 <=90
and if B1= < 25
then c1 = 0.41
or if B1= >25 and <= 30 years
then c1 = 0.52
4. If A1 >90 <=95
and if B1= < 25
then c1 = 0.67
or if B1= >25 and <= 30 years
then c1 = 0.78
5. If the loan percentage is >95 <=100
Return value = "NA"
Bookmarks