80;-10",5;",80;,92}%,14,85,88,85,",75,60;+10"=5,求帮助,14,1)<,50,{-20,-2,-14,-5,"!,92}%,-14,-9,$J$6;=5,9;))
效果还是没显示,88,5,"+10":$J$101,70,$J$6,-9,$J$6,70,20})&IF(RANK(J21,90;",75!,20})&IF(RANK(J7,-2,60,50;,2:$J$101)<:$J$101)<,2;=5,{-20,9,{0,IF(RANK(J21,",")
现在后面加你的公式是=LOOKUP(J6,90,急我开始的公式是=LOOKUP(J7,-5,{0
excel表里做了前5名加10分,是IF(RANK(J21,$J$6:$J$101)<=5,"+10"," "),怎以加上
答案:3 悬赏:40
解决时间 2021-02-20 12:19
- 提问者网友:敏感魔鬼
- 2021-02-19 15:04
最佳答案
- 二级知识专家网友:旧事诱惑
- 2021-02-19 15:20
+10"=5,"=5,",1)<,",$J$6,IF(RANK(J21:$J$101)<,$J$6;;":$J$101;-10"=IF(RANK(J21
全部回答
- 1楼网友:转身→时光静好
- 2021-02-19 17:11
你好!
$J$101;6,IF(RANK(J21,+10:$J$101)<,$J$6;6,-10,$J$6,1)<=IF(RANK(J21
如果对你有帮助,望采纳。
- 2楼网友:怪咖小青年
- 2021-02-19 16:49
公式:=IF(RANK(J21,$J$6:$J$101)<=5,"+10",IF(RANK(J21,$J$6:$J$101,1)<=5,"-10"," "))
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯