求大佬帮忙解释下公式逻辑，跪谢。

相约明天

求大佬帮忙解释下公式中{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}是怎么计算出来的，谢谢。
附件.rar (10.34 KB, 下载次数: 13)

2021-9-24 09:45 上传

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

前缘今续

你这问的，都不知道是在算什么

彭英珍

=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}是怎么计算出来的

果大爷

大佬们一般用TEXT算

幸福咫尺天涯

好的，谢谢，主要就是想学习下公式当中的逻辑。

专捉长白山下通古斯野猪皮

那几个数是前面几档的提成。

雷小东

你公式在计算什么？不知道在计算什么，怎么知道为什么写这数组

白画心

谢谢大神