请老师帮助做个公式 谢谢

夏小淞

麻烦各位大神了 十分感谢

夏小淞

请老师帮助做个公式

夏小淞

还有个公式到100那容易出现FALSE,请老师看看，给修改下=IF(E8="",0,IF(E8<=13,6500,IF(E8<=15,4000,IF(E8<=17,3000,IF(E8<=19,2800,IF(E8<=20,2700,IF(E8<=22,2500,IF(E8<=23,2400,IF(E8<=23,2400,IF(E8<=32,2300,IF(E8<=48,2200,IF(E8<=65,2300,IF(E8="30白平口",2500,IF(E8="32白平口",2500,IF(E8="45平口",2200,IF(E8="52平口",2200,IF(E8="55平口",2200,IF(E8="60平口",2200,IF(E8="80平口",2200,IF(E8=100,2200,IF(E8="110平口",2200,IF(E8="120平口",2200,IF(E8="23彩白",2500,IF(E8="25彩白",2200,IF(E8="23彩黄",2500,IF(E8="26彩白",2500,IF(E8="","")))))))))))))))))))))))))))