将公式=IF(A1=defds123quot;酒defds123quot;,24,IF(A1=defds123quot;水defds123quot;,12,defds123quot;defds123quot;))粘贴至B2单元格,如图:<img src=\\\"http://p8.qhimg.com/t011fb59df1a9b58da8.png\\\">A1单元格输入数据,如图:<img src=\\\"http://p0.qhimg.com/t0155ef5ad4106cb5c9.png\\\"><img src=\\\"http://p0.qhimg.com/t01172898f382877d3a.png\\\">
|