IF条件-逻辑判断.doc

《IF条件-逻辑判断.doc》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、判断比例=IF(O5>0.6,"高",IF(O5>0.5,"中",IF(O5>0.4,"低",IF(O5>0.3,"极低",IF(O5>0.2,"超极低",IF(O5>0.1,"不可想象超极低",IF(O5>0,"简直不可思议超极低")))))))城镇居民住院总费用分段报销=IF(H8<2200,IF(ROUND(SUM(H8-P8-Q8-R8*0.1)*0.65,0)<30000,ROUND(SUM(H8-P8-Q8-R8*0.1)*0.65,0),30000),IF(H8<4000,IF(ROUND(SUM(H8-P8-Q8-R8*0.1)*0.6,0)

2、<30000,ROUND(SUM(H8-P8-Q8-R8*0.1)*0.6,0),30000),IF(H8<6000,IF(ROUND(SUM(H8-P8-Q8-R8*0.1)*0.55,0)<30000,ROUND(SUM(H8-P8-Q8-R8*0.1)*0.55,0),30000),IF(H8>6000,IF(ROUND(SUM(H8-P8-Q8-R8*0.1)*0.5,0)<30000,ROUND(SUM(H8-P8-Q8-R8*0.1)*0.5,0))))))城镇职工分年龄按照比例报销=IF(F10<45,IF(ROUND(SUM(I10-P10-

3、Q10*0.1-S10)*0.8,1)<80000,ROUND(SUM(I10-P10-Q10*0.1-S10)*0.8,1),80000),IF(F10>=45,IF(ROUND(SUM(I10-P10-Q10*0.1-S10)*0.85,1)<80000,ROUND(SUM(I10-P10-Q10*0.1-S10)*0.85,1),80000),IF(F10>=60,IF(ROUND(SUM(I10-P10-Q10*0.1-S10)*0.9,1)<80000,ROUND(SUM(I10-P10-Q10*0.1-S10)*0.9,1),80000))))城

4、镇职工报补充=IF(F8<60,IF(ROUND(SUM(I8-P8-Y8-AA8-450)*0.8,1)<200000,ROUND(SUM(I8-P8-Y8-AA8-450)*0.8,1),200000),IF(F8>=60,IF(ROUND(SUM(I8-P8-Y8-AA8-350)*0.8,1)<200000,ROUND(SUM(I8-P8-Y8-AA8-350)*0.8,1),200000)))城镇职工报公补=IF(F8<60,IF(ROUND(SUM(I8-P8-Y8-450)*0.6,1)<20000,ROUND(SUM(I8-P8-Y8-450

5、)*0.6,1),20000),IF(F8>=60,IF(ROUND(SUM(I8-P8-Y8-350)*0.6,1)<20000,ROUND(SUM(I8-P8-Y8-350)*0.6,1),20000)))城镇职工自动动识别男性女性E8性别F8年龄I8住院总费用Q8起付线R8不予支付费用S8乙类自付费用=IF(E8="女",IF(F8>=55,IF(ROUND(SUM(I8-Q8-R8-S8)*0.9,1)<25000,ROUND(SUM(I8-Q8-R8-S8)*0.9,1),25000),IF(F8>=45,IF(ROUND(SUM(I8-Q8-R8

6、-S8)*0.85,1)<25000,ROUND(SUM(I8-Q8-R8-S8)*0.85,1),25000),IF(F8<45,IF(ROUND(SUM(I8-Q8-R8-S8)*0.8,1)<25000,ROUND(SUM(I8-Q8-R8-S8)*0.8,1),25000)))),IF(E8="男",IF(F8>=60,IF(ROUND(SUM(I8-Q8-R8-S8)*0.9,1)<25000,ROUND(SUM(I8-Q8-R8-S8)*0.9,1),25000),IF(F8>=45,IF(ROUND(SUM(I8-Q8-R8-S8)*0.85,

7、1)<25000,ROUND(SUM(I8-Q8-R8-S8)*0.85,1),25000),IF(F8<45,IF(ROUND(SUM(I8-Q8-R8-S8)*0.8,1)<25000,ROUND(SUM(I8-Q8-R8-S8)*0.8,1),25000))))))