excel2010常用经典函数演示

查找“Emma”的年龄：

常用解决方法：

if函数=IF(A2<60,"差",IF(A2<80,"中",IF(A2<90,"良","优"))) =VLOOKUP(A3,$D$3:$E$6,2,1)

vlookup函数

数组'=VLOOKUP(A3,{0,"差";60,"中";80,"良";90,"优"},2,1)

2 1 2 1 1 1 1

1