个人总结,汇集了基本上日常使用的excel函数,简单易懂,让您的数据处理更加得心应手。

1 lookup 関数

=LOOKUP(A1,{"a","b","c","d","e","h","I"},{9,9,8.5,8,7,5,4})

这个最直观也最容易，

2. if関数

if怎么在数据中设置《优 》《良》《 中》《 差》《 极差》这几个条件啊？IF函数不能同时输入这么多条件啊？怎么办

=IF(A1>7,"优",IF(A1>5,"良",IF(A1>4,"中",IF(A1>3,"差","极差"))))

或者

=IF(OR(A1={2,3}),"极差",IF(A1=4,"差",IF(A1=5,"中",IF(OR(A1={6,7}),"良",IF(A1=8,"优","")))))

可以用lookup函数做

=LOOKUP(A1,{2,4,5,6,8},{"极差","差","中","良","优"})

单元格的7层以上的引用

=IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",IF(A1=5,"E",IF(A1=6,"F",IF(A1=7,"G",IF(A1=8,"H",""))))))))&IF(A1=9,"I",IF(A1=10,"J",IF(A1=11,"K",IF(A1=12,"L",IF(A1=13,"M",IF(A1=14,"N",IF(A1=15,"O",IF(A1=16,"P",""))))))))&IF(A1=17,"Q",IF(A1=18,"R",IF(A1=19,"S",IF(A1=20,"T",IF(A1=21,"U",IF(A1=22,"V",IF(A1=23,"W",IF(A1=24,"X",""))))))))&IF(A1=25,"Y",IF(A1=26,"Z",""))。

方法2

A1=IF(A1=1,"A",IF(A1=2,"B",IF(A1=3,"C",IF(A1=4,"D",IF(A1=5,"E",IF(A1=6,"F",IF(A1=7,"G",IF(A1=8,"H","A2")))))))

A2=IF(A2=9,"I",IF(A2=10,"J",IF(A2=11,"K",IF(A2=12,"L",IF(A2=13,"M",IF(A2=14,"N",IF(A2=15,"O",IF(A2=16,"P","A3")))))))).

A3=IF(A3=17,"Q",IF(A3=18,"R",IF(A3=19,"S",IF(A3=20,"T",IF(A3=21,"U",IF(A3=22,"V",IF(A3=23,"W",IF(A3=