电子表如果说B1等于1时,A1等于A,B1等于2,A1等于B,B1等于3,A1等于C,一直到B1等于20 A1等于T
电子表如果说B1等于1时,A1等于A,B1等于2,A1等于B,B1等于3,A1等于C,一直到B1等于20 A1等于T
=IF(OR(B1=1,"A",B1=2,"B",B1=3,"C",B1=4,"D",B1=5,"E",B1=6,"F",B1=9,"G",B1=10,"H",B1=11,"J",B1=12,"K",B1=13,"L",B1=14,"M",B1=15,"S"),)
在插入—函数—里面选IF的 然后再以点一点设置,不过你这个比较多就需要设置多个IF好像设置到一定的数量就没有不能设置了=IF(B1=1,"A",IF(B1=2,"B",IF(B1=3,"C",IF(B1=4,"D",IF(B1=5,"E",IF(B1=6,"F",IF(B1=9,"G",IF(B1=10,"H",IF(B1=11,"J",IF(B1=12,"K",IF(B1=13,"L",IF(B1=14,"M",IF(B1=15,"S"))))))))我用的是2003版本的 提示是做多7个=IF(B1=1,"A",IF(B1=2,"B",IF(B1=3,"C",IF(B1=4,"D",IF(B1=5,"E",IF(B1=6,"F",IF(B1=9,"G",IF(B1=10,"H",IF(B1=11,"J",IF(B1=12,"K",IF(B1=13,"L",IF(B1=14,"M",IF(B1=15,"S"))))))))设置到H时就不行了是啊 做多7个。。。。。要不你弄个宏式一下能不能行吧那个不会呀你可用试下，看这个方法行不行，当IF判断为错时引用另一个单元格，然后再另一个单元格里面设置H之后的判断式，看看能不能实现你说的不行的，那样太乱了我也没有更好的办法了，只能先试试这个了，表格不像可编译的程序一样有那么多的扩展空间。。。。。先谢谢你了我也是没有办法才这个样子的客气了