国产一区二区欧美精品免费-欧美国产日韩在线视频-欧美亚洲国语精品一区二区-欧美激情五月综合啪啪-国产69精品麻豆久久久久-亚洲人成精品久久久久桥网站-欧美刺激肥熟在线视频-十七岁日本免费完整版BD-黑夜在线拖拽不卡第一页

=IFS(Q2<0.5,0,AND(Q2>=0.5,Q2<1.5),20,AND(Q2>=1.5,Q2<2.5),30,AND(Q2>=2.5,Q2<3.5),40,AND(Q2>=3.5,Q2<4.5),50,AND(Q2>4.5,Q2<5.5),60,AND(Q2>5.5,Q2<6.5),70,AND(Q2>6.5,Q2<7.5),80,AND(Q2>=7.5,Q2<8.5),90,AND(Q2>=8.5,Q2<9.5),100,AND(Q2>=9.5,Q2<10.5),110,AND(Q2>=10.5,Q2<11.5),120,AND(Q2>=11.5,Q2<12.5),130,AND(Q2>=12.5,Q2<13.5),140)

這個公式該怎么簡化，一開始我想到四舍五入，但是好像解決不了當Q2等于1.5,2.5,這些特殊情況，怎么都想不出來，只能用笨辦法寫一長串。