excel中条件包含

单元格中包含某些字符时，显示为某些字符

=IF(ISNUMBER(FIND("混凝土垫层",C3)),"C20",IF(ISNUMBER(FIND("台　扩大基础　混凝土施工",C3)),"C25片石砼",IF(ISNUMBER(FIND("墩　扩大基础　混凝土施工",C3)),"C30",IF(ISNUMBER(FIND("墩柱　混凝土施工",C3)),"C40",IF(ISNUMBER(FIND("第一次浇筑　混凝土施工",C3)),"C25片石砼",IF(ISNUMBER(FIND("第二次浇筑　混凝土施工",C3)),"C25片石砼",IF(ISNUMBER(FIND("第二次浇筑(台背)　混凝土施工",C3)),"C30",IF(ISNUMBER(FIND("混凝土垫层",C3)),"C20",IF(ISNUMBER(FIND("台帽　混凝土施工",C3)),"C30",IF(ISNUMBER(FIND("台背　混凝土施工",C3)),"C30",IF(ISNUMBER(FIND("档块及支座垫石　混凝土施工",C3)),"C40",IF(ISNUMBER(FIND("现浇连续实心板　混凝土施工",C3)),"C40",IF(ISNUMBER(FIND("盖梁　混凝土施工",C3)),"C40",IF(ISNUMBER(FIND("混凝土施工(灌注)",C3)),"C30水下","错误")))))))))

单元格中为某些字符时，显示为某些字符

=LOOKUP(C21,{6,8,10,12,14,16,18,20,22,25,28,32,36,40},{0.222,0.395,0.617,0.888,1.21,1.58,2,2.47,2.98,3.85,4.83,6.31,7.99,9.87})