Excel求aqi

PM10
=ROUNDUP(IF(CI2<0.05,50*CI2/0.050,IF(CI2<0.15,50*(CI2-0.050)/0.100+50,IF(CI2<0.250,50*(CI2-0.150)/0.100+100,IF(CI2<0.350,50*(CI2-0.250)/0.100+150,IF(CI2<0.420,100*(CI2-0.350)/0.070+200,IF(CI2<0.500,100*(CI2-0.420)/0.080+300,IF(CI2<0.600,100*(CI2-0.500)/0.100+400))))))),0)


SO2
=ROUNDUP(IF(CJ2<0.05,50*CJ2/0.050,IF(CJ2<0.15,50*(CJ2-0.050)/0.100+50,IF(CJ2<0.475,50*(CJ2-0.150)/0.325+100,IF(CJ2<0.800,50*(CJ2-0.475)/0.325+150,IF(CJ2<1.600,100*(CJ2-0.800)/ 0.800+200,IF(CJ2<2.100,100*(CJ2-1.600)/0.500+300,IF(CJ2<2.620,100*(CJ2-2.100)/0.520+400))))))),0)


NO2
=ROUNDUP(IF(CK2<0.04,50*CK2/0.040,IF(CK2<0.08,50*(CK2-0.040)/0.040+50,IF(CK2<0.180,50*(CK2-0.080)/0.100+100,IF(CK2<0.280,50*(CK2-0.180)/0.100+150,IF(CK2<0.565,100*(CK2-0.280)/0.285+200,IF(CK2<0.750,100*(CK2-0.565)/0.185+300,IF(CK2<0.940,100*(CK2-0.750)/ 0.190+400))))))),0)