求大佬帮忙解释下公式

陈双

=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}是怎么算的。

绍吉

上传附件看

吸人血的影子

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

鬼牙

麻烦看下，谢谢
附件.rar (10.34 KB, 下载次数: 25)

2021-9-23 16:49 上传

点击文件名下载附件
附件.rar

网事如疯

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