第一问答网»论坛 › 中问网 › 问答 › excel 当e1为x，e2为y时，j1,j2显示a?

excel 当e1为x，e2为y时，j1,j2显示a?

11 |

3 | 2012-8-3 17:03:18 | 显示全部楼层 |阅读模式

E1=X,E2=Y时J1,J2为Aj1,j2输入公式=if(and(e1="x",e2="y"),"a","")E1=X时J1为A,E2=Y时J2为AJ1=IF(E1="X","A","")J2=IF(E2="Y","A","")两种情况,你自已选一下你要的公式只要j1显示a也可以，那么什么口令可以当j1等于a时j2也显示a?J1 =if(and(e1="x",e2="y"),"a","")J2 =IF(J1="A",J1,"")...

使用道具举报