问个execl if函数 原公式为 =IF(O1=A2,O1,IF(O1=B2,O1,IF(O1=C2,O1,IF(O1=D2,O1,IF(O1=E2,O1,IF(O1=F2,O1,""))))))复制公式后变 =IF(P1=B2,P1,IF(P1=C2,P1,IF(P1=D2,P1,IF(P1=E2,P1,IF(P1=F2,P1,IF(P1=G2,P1,""))))))我想要的公式是:=IF(P1=A2,P
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/02 04:48:38
![问个execl if函数 原公式为 =IF(O1=A2,O1,IF(O1=B2,O1,IF(O1=C2,O1,IF(O1=D2,O1,IF(O1=E2,O1,IF(O1=F2,O1,](/uploads/image/z/7139254-22-4.jpg?t=%E9%97%AE%E4%B8%AAexecl+if%E5%87%BD%E6%95%B0+%E5%8E%9F%E5%85%AC%E5%BC%8F%E4%B8%BA+%3DIF%28O1%3DA2%2CO1%2CIF%28O1%3DB2%2CO1%2CIF%28O1%3DC2%2CO1%2CIF%28O1%3DD2%2CO1%2CIF%28O1%3DE2%2CO1%2CIF%28O1%3DF2%2CO1%2C%22%22%29%29%29%29%29%29%E5%A4%8D%E5%88%B6%E5%85%AC%E5%BC%8F%E5%90%8E%E5%8F%98+%3DIF%28P1%3DB2%2CP1%2CIF%28P1%3DC2%2CP1%2CIF%28P1%3DD2%2CP1%2CIF%28P1%3DE2%2CP1%2CIF%28P1%3DF2%2CP1%2CIF%28P1%3DG2%2CP1%2C%22%22%29%29%29%29%29%29%E6%88%91%E6%83%B3%E8%A6%81%E7%9A%84%E5%85%AC%E5%BC%8F%E6%98%AF%EF%BC%9A%3DIF%28P1%3DA2%2CP)
问个execl if函数 原公式为 =IF(O1=A2,O1,IF(O1=B2,O1,IF(O1=C2,O1,IF(O1=D2,O1,IF(O1=E2,O1,IF(O1=F2,O1,""))))))复制公式后变 =IF(P1=B2,P1,IF(P1=C2,P1,IF(P1=D2,P1,IF(P1=E2,P1,IF(P1=F2,P1,IF(P1=G2,P1,""))))))我想要的公式是:=IF(P1=A2,P
问个execl if函数
原公式为 =IF(O1=A2,O1,IF(O1=B2,O1,IF(O1=C2,O1,IF(O1=D2,O1,IF(O1=E2,O1,IF(O1=F2,O1,""))))))
复制公式后变 =IF(P1=B2,P1,IF(P1=C2,P1,IF(P1=D2,P1,IF(P1=E2,P1,IF(P1=F2,P1,IF(P1=G2,P1,""))))))
我想要的公式是:=IF(P1=A2,P1,IF(P1=B2,P1,IF(P1=C2,P1,IF(P1=D2,P1,IF(P1=E2,P1,IF(P1=F2,P1,""))))))
应该怎么处理呀?
问个execl if函数 原公式为 =IF(O1=A2,O1,IF(O1=B2,O1,IF(O1=C2,O1,IF(O1=D2,O1,IF(O1=E2,O1,IF(O1=F2,O1,""))))))复制公式后变 =IF(P1=B2,P1,IF(P1=C2,P1,IF(P1=D2,P1,IF(P1=E2,P1,IF(P1=F2,P1,IF(P1=G2,P1,""))))))我想要的公式是:=IF(P1=A2,P
原公式改成这样就行:
=IF(O1=$A2,O1,IF(O1=$B2,O1,IF(O1=$C2,O1,IF(O1=$D2,O1,IF(O1=$E2,O1,IF(O1=$F2,O1,""))))))