=IF(B33,MIN(B33)*LOO

时间2023-05-29 22:13:09 提问来自 未知 的网友 分类ChatGPT提问 浏览160 热度0
UM(B33)*LOOKUP(MIN(B33),$A$1:$A$10,$C$1:C10),$A$1:$A$10, $D I'm not sure what you're trying to do here. If I understand correctly, you want to find the value in column D that corresponds to the sum of B33 multiplied by the minimum of B33. If this is correct, you can use a combination of INDEX and MATCH functions like this: <code>=INDEX($D$1:D10,MATCH(SUM(B33)*MIN(B33), $A$1: $A10))</code>

AI智能问答网免责声明:
以上内容除特别注明外均来源于网友提问、ChatGPT回答,权益归原著者所有,本站仅作效果演示和欣赏之用;
若以上展示有冒犯或侵害到您,敬请联系我们进行删除处理,谢谢!

上一篇 写一个excel公式,当B33大于等于5 下一篇 搜索框的用法