[已解决]如何用一个公式确定提成率

LVAN_TJ · 发表于 2010-9-6 15:06

本帖最后由爱疯于 2015-3-27 09:42 编辑

QQ截图20150327093727.jpg

提成计算.rar (6.42 KB, 下载次数: 1)

那么的帅 · 发表于 2010-9-6 15:11

=VLOOKUP(C11-0.00001,{0,0;0.92,0.003;0.96,0.008;0.98,0.01},2) 不包括上限

或者 =VLOOKUP(C11,{0,0;0.92,0.003;0.96,0.008;0.98,0.01},2) 包括上限

cjainwei · 发表于 2010-9-6 15:12

本帖最后由爱疯于 2015-3-27 09:44 编辑

=LOOKUP(C11,{0,0;0.92,0.3;0.96,0.8;0.98,1})

chensir · 发表于 2010-9-6 15:15

=VLOOKUP(C11,{0,0;0.92,0.003;0.96,0.008;0.98,0.01},2,1)

VlCeqLaW.rar (1.96 KB, 下载次数: 2)

		自动登录	找回密码
密码			注册