close

I need to calculate commissions on this sliding scale:
0-94.9% -2%
95%-99.9%0%
100%-104.9%1%
105% PLUS2%
How can I set this up with vlookup?Try something like this:

With this table set up in A1:B4

RefCol_ACol_B
Row_10%-2%
Row_295%0%
Row_3100%1%
Row_4105%2%

C1: (a percentage to be looked up)
D1: =VLOOKUP(C1,$A$1:$B$4,2,1)

note: format all value as percents

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;kellyquot; wrote:

gt; I need to calculate commissions on this sliding scale:
gt; 0-94.9% -2%
gt; 95%-99.9%0%
gt; 100%-104.9%1%
gt; 105% PLUS2%
gt; How can I set this up with vlookup?
gt;

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()

    E-mail轉寄