锁哥:
一定要用IF的话,可以用连接符号把一个IF连起来=IF(B4="XGH001","1.5KG","")&IF(B4="XGH002","2KG","")这样,建议用VLOOKUP之类的查找与引用函数。比如=VLOOKUP(B4,{"XGH001","1.5KG";"XGH002","2KG";"XGH003","4KG";"XGH004","9KG";"XGH005","10KG"},2,FALSE)也可其中那个数据放在表格的一个地方作为辅助区域,这样公式可以很短,比如放在F1:G20中,=VL....