能不能使用函数

溪边小径

能不能使用函数

丢丢表格

=LOOKUP(B7,{-1,60,70,80,80,100}+1%,{"极差","差","中","良","优","极优"})

问山8828680

LOOKUP(B7,{0,6,7,8,9,10}*10+1%%,$B$2:$G$2)

QYSXY2007

=IF(B7<=60,$B$2,IF(AND(B7>60,B7<=70),$C$2,IF(AND(B7>70,B7<=80),$D$2,IF(AND(B7>80,B7<=90),$E$2,IF(AND(B7>90,B7<=100),$F$2,IF(B7>100,$G$2))))))

sayhi95

1. =VLOOKUP(B7,{0,"极差";60.001,"差";70.001,"中";80.001,"良";90.001,"优";100.001,"极优"},2)

复制代码

wswfzwswfz

QYSXY2007 发表于 2015-10-8 09:36
=IF(B760,B770,B780,B790,B7100,$G$2))))))

=IF(B7<=60,"极差",IF(B7<=70,"差",IF(B7<=80,"中",IF(B7<=90,"良",IF(B7<=100,"优","极优")))))

中间的and不要的

QYSXY2007

wswfzwswfz 发表于 2015-10-8 09:47
=IF(B7

是啊，谢谢。