vlookup & lookup

  

=IF(AND(A1>=0,A1<0.03125),115%,IF(AND(A1>=0.03125,A1<0.125),112%,IF(AND(A1>=0.125,A1<0.25),109%,IF(AND(A1>=0.25,A1<0.375),106%,IF(AND(A1>=0.375,A1<0.5),103%,IF(AND(A1>=0.5,A1<1),100%,IF(AND(A1>=1,A1<2),96%,IF(AND(A1>=2,A1<3),92%,IF(AND(A1>=3,A1<4),86%,IF(AND(A1>=4,A1<5),82%,IF(AND(A1>=5,A1<6),78%,IF(AND(A1>=6,A1<=7),73%,IF(AND(A1>=7,A1<8),69%,IF(AND(A1>=8,A1<9),65%,IF(AND(A1>=9,A1<10),60%,IF(AND(A1>=10,A1<11),56%,IF(AND(A1>=11,A1<12),51%,IF(AND(A1>=12,A1<13),47%,IF(AND(A1>=13,A1<14),42%,IF(AND(A1>=14,A1<15),38%,IF(AND(A1>=15,A1<16),33%,IF(AND(A1>=16,A1<17),29%,IF(AND(A1>=17,A1<18),24%,IF(AND(A1>=18,A1<19),20%,IF(AND(A1>=19,A1<20),16%,IF(AND(A1>=20,A1<21),11%,IF(AND(A1>=21,A1<22),7%,IF(AND(A1>=22,A1<23),2%,IF(AND(A1>=23),0%,"無值" )))))))))))))))))))))))))))))



=VLOOKUP(A2,$D$2:$E$29,2)



=IF(LOOKUP($G2,{0,60,70,80,90},$A$1:$E$1)=A$1,$F2,"")