各路大神，求助公式，具体见附件

chengjun197 · 发表于 2018-2-26 11:06

如何按照右图设置公式，在对应单元格内打上√，小于20，为空白

丢丢表格 · 发表于 2018-2-26 11:27

本帖最后由丢丢表格于 2018-2-26 11:55 编辑

=TRANSPOSE(FREQUENCY(P5,{999,319,159,69,19}))

小晴哥 · 发表于 2018-2-26 11:32

用if函数实现

renyz2006 · 发表于 2018-2-26 11:35

q5=IF($P5<20,"",IF(LOOKUP($P5,{20,70,160,320,800},{"D","C","B","A"})=Q$4,"√",""))右拉下拉即可！

cjc209 · 发表于 2018-2-26 11:38

Q5=IF(OR(LOOKUP($P5,{0,0;20,"D";70,"C";160,"B";320,"A"})=0,LOOKUP($P5,{0,0;20,"D";70,"C";160,"B";320,"A"})<>Q$4),"","√") 右拉下拉

mengrs · 发表于 2018-2-26 11:47

=IF(LOOKUP($P5,{0,0;20,"D";70,"C";160,"B";320,"A"})=Q$4,"√","")

zengyidin · 发表于 2018-2-26 14:23

供参考，右拉下拉

复制代码

chengjun197 · 发表于 2018-2-28 09:18

mengrs 发表于 2018-2-26 11:47
=IF(LOOKUP($P5,{0,0;20,"D";70,"C";160,"B";320,"A"})=Q$4,"√","")

完美解决感谢大师

gao05499 · 发表于 2018-3-8 16:14

=IF(IF($P20>=320,"A",IF($P20>=160,"B",IF($P20>=70,"C",IF($P20>=20,"D",""))))=Q$19,"√","")

		自动登录	找回密码
密码			免费注册

[已解决] 各路大神，求助公式，具体见附件