EXCEL中,A=1.1,B=“一等”则C=1.1;A=1.1,B="二等"则C=1.0;以此类推
来源:学生作业帮助网 编辑:作业帮 时间:2024/06/29 23:34:24
![EXCEL中,A=1.1,B=“一等”则C=1.1;A=1.1,B=](/uploads/image/z/8661039-15-9.jpg?t=EXCEL%E4%B8%AD%2CA%3D1.1%2CB%3D%E2%80%9C%E4%B8%80%E7%AD%89%E2%80%9D%E5%88%99C%3D1.1%3BA%3D1.1%2CB%3D%22%E4%BA%8C%E7%AD%89%22%E5%88%99C%3D1.0%3B%E4%BB%A5%E6%AD%A4%E7%B1%BB%E6%8E%A8)
EXCEL中,A=1.1,B=“一等”则C=1.1;A=1.1,B="二等"则C=1.0;以此类推
EXCEL中,A=1.1,B=“一等”则C=1.1;A=1.1,B="二等"则C=1.0;以此类推
EXCEL中,A=1.1,B=“一等”则C=1.1;A=1.1,B="二等"则C=1.0;以此类推
C2单元格输入以下公式,然后向下填充公式
=A2-VLOOKUP(B2,{"一等",0;"二等",0.1;"三等",0.2;……},2,0)