Office学习社区 › 公式和函数 › 求大佬帮忙解释下公式

陈双 发表于 2021-9-23 16:49:00

求大佬帮忙解释下公式

=LOOKUP(C3/10000,{0,20,40,50,60,80,100},(C3/10000-{0,20,40,50,60,80,100})*{0.01,0.02,0.03,0.04,0.05,0.06,0.07}+{0,0.2,0.6,0.9,1.3,2.3,3.5})*10000

=LOOKUP(C3/10000,{0,20,40,50,60,80,100},(C3/10000-{0,20,40,50,60,80,100})*{0.01,0.02,0.03,0.04,0.05,0.06,0.07}+{0,0.1,0.3,0.35,0.45,1.05,1.75})*10000

求大佬帮忙解释下公式中{0,0.2,0.6,0.9,1.3,2.3,3.5}，{0,0.1,0.3,0.35,0.45,1.05,1.75}是怎么算的。

绍吉 发表于 2021-10-28 23:54:58

上传附件看

吸人血的影子 发表于 2021-10-29 09:42:07

给你上个 精缩版
=SUM(TEXT(C3%%-{0,20,40,50,60,80,100},"[<]!0")/1%)

鬼牙 发表于 2021-11-6 18:56:37

麻烦看下，谢谢

网事如疯 发表于 2021-12-14 17:39:54

谢谢，就是想明白里面的公式是怎么计算出来的，方便学习

查看完整版本: 求大佬帮忙解释下公式