Excel formula / code for calculating value based on multiple cells - 2

Hi! thank you very much for your early reply! it helped me a lot!

I have a similar problem:


cell: A1 = 1st data
cell: B1 = 2nd data

cell: C1 = 3rd data


1. If A1 = 85 (exact 85 only)
and if B1= < 25
then c1 = 0.21

or if B1= >25 and <= 30
then c1 = 0.32

2. If A1 >=1 and < 85
and if B1= < 25
then c1 = 0.32

or if B1= >25 and <= 30
then c1 = 0.32

3. If A1 >85 <=90
and if B1= < 25
then c1 = 0.41

or if B1= >25 and <= 30
then c1 = 0.52

4. If A1 >90 <=95
and if B1= < 25
then c1 = 0.67

or if B1= >25 and <= 30
then c1 = 0.78

5. If the loan percentage is >95 <=100
Return value = "NA"