excel函数经验收藏

1. switch语句

作用:对某一列或某一个单元格的数据进行变换处理

例如:将一列城市编码转换成中文

SWITCH(M2,"330100","杭州","330200","宁波","330300","温州","330400","嘉兴","330500","湖州","330600","绍兴","330700","金华","330800","衢州","330900","舟山","331000","台州","331100","丽水","330703","义乌","不匹配")

 

2.If语句

作用:对某一个单元格的值进行条件判断，并根据结果返回设定的值

例如:将性别代码转换为中文

IF(E2="1","男","女")

 

3.快速选中一列或一行数据

shift+ctrl+方向键

 

4.ISBLANK函数

判断单元格的值是否为空

 

5. AND(表达式1,表达式2...)    OR(表达式1,表达式2)