house802 house802
关注数: 1 粉丝数: 22 发帖数: 648 关注贴吧数: 21
excel中函数IF判断。提示公式错误 单独拿出来都没错。而且两三个套用也没错。就一多喽就报错 =IF( ISNUMBER(FIND(M2,"天津市")), IF(C2<=1,2.5,IF(C2<2,3.2,IF(C2<3,3.5,IF(C2<=4,6,IF(C2<=5,6.5,4+(ROUNDUP(C2,0)-1)*1))))), IF( ISNUMBER(FIND(M2,"北京市,上海")), IF(C2<=1,2.8,IF(C2<2,3.4,IF(C2<3,3.8,IF(C2<=4,6.2,IF(C2<=5,6.8,5+(ROUNDUP(C2,0)-1)*2))))), IF( ISNUMBER(FIND(M2,"河北省、山东省")), IF(C2<=1,2.5,IF(C2<2,3.2,IF(C2<3,3.5,IF(C2<=4,5.7,IF(C2<=5,6.3,4+(ROUNDUP(C2,0)-1)*2))))), IF( ISNUMBER(FIND(M2,"江苏省、浙江省、安徽省、黑龙江省、吉林省、辽宁省、山西省、河南省、湖北省")), IF(C2<=1,2.5,IF(C2<2,3.2,IF(C2<3,3.5,IF(C2<=4,6,IF(C2<=5,6.5,5+(ROUNDUP(C2,0)-1)*2))))), IF( ISNUMBER(FIND(M2,"陕西省")), IF(C2<=1,2.5,IF(C2<2,3.2,IF(C2<3,3.5,IF(C2<=4,6,IF(C2<=5,6.5,5+(ROUNDUP(C2,0)-1)*3))))), IF( ISNUMBER(FIND(M2,"湖南省、江西省、四川省、福建省、广东省、重庆市、四川省、重庆市")), IF(C2<=1,2.5,IF(C2<2,3.2,IF(C2<3,3.5,IF(C2<=4,6,IF(C2<=5,6.5,7+(ROUNDUP(C2,0)-1)*3.5))))), IF( ISNUMBER(FIND(M2,"贵州省、甘肃省、广西省、云南省、宁夏、青海")), IF(C2<=1,2.5,IF(C2<2,3.2,IF(C2<3,3.5,IF(C2<=4,6,IF(C2<=5,6.5,8+(ROUNDUP(C2,0)-1)*4.5))))), IF( ISNUMBER(FIND(M2,"海南,内蒙")), 8.5+(ROUNDUP(C2,0)-1)*6.5, IF( ISNUMBER(FIND(M2,"新疆")), 19+(ROUNDUP(C2,0)-1)*16, IF( ISNUMBER(FIND(M2,"西藏")), 22+(ROUNDUP(C2,0)-1)*18, IF(C2<=1,2.8,IF(C2<2,3.4,IF(C2<3,3.8,IF(C2<=4,6.2,IF(C2<=5,6.8,5+(ROUNDUP(C2,0)-1)*2))))) ) ) ) ) ) ) ) ) ) )
1 下一页