单独拿出来都没错。而且两三个套用也没错。就一多喽就报错
=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)))))
)
)
)
)
)
)
)
)
)
)
=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)))))
)
)
)
)
)
)
)
)
)
)


