求精简公式？ 5
=IF(SUMPRODUCT(($B$2:$B$860=$B2)*(D$2:D$860>D2))/COUNTIFS($B$2:$B$860,$B2)<0.15,"A",I...
=IF(SUMPRODUCT(($B$2:$B$860=$B2)*(D$2:D$860>D2))/COUNTIFS($B$2:$B$860,$B2)<0.15,"A",IF(SUMPRODUCT(($B$2:$B$860=$B2)*(D$2:D$860>D2))/COUNTIFS($B$2:$B$860,$B2)<0.4,"B",IF(SUMPRODUCT(($B$2:$B$860=$B2)*(D$2:D$860>D2))/COUNTIFS($B$2:$B$860,$B2)<0.8,"C",IF(SUMPRODUCT(($B$2:$B$860=$B2)*(D$2:D$860>D2))/COUNTIFS($B$2:$B$860,$B2)<0.95,"D","E"))))
展开
1个回答
展开全部
<号之前的条件是相兆返穗同的，相同的条件替代下面A3
=LOOKUP(A3,{0,0.15,0.4,0.8,0.95},{"A","世尘B","C","族卜D","E"})
=LOOKUP(A3,{0,0.15,0.4,0.8,0.95},{"A","世尘B","C","族卜D","E"})
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
AiPPT
2024-09-19 广告
随着AI技术的飞速发展，如今市面上涌现了许多实用易操作的AI生成工具1、简介：AiPPT: 这款AI工具智能理解用户输入的主题，提供“AI智能生成”和“导入本地大纲”的选项，生成的PPT内容丰富多样，可自由编辑和添加元素，图表类型包括柱状图...
点击进入详情页
本回答由AiPPT提供
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
