Vlookup or if

<!–td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}–>

    up front/ annually quarterly/monthly
$1,000 $4,999 5%  
$5,000 $49,999 10% 5%
$50,000 $99,999 15% 10%
$100,000 $249,999 20% 15%
$250,000 $499,999 25% 20%
$500,000 $999,999 30% 25%
$1,000,000 $2,499,999 35% 30%
$2,500,000 $4,999,999 40% 35%
$5,000,000   45% 40%

How would I do a vlook up or if function for a number that falls into the range and the category in order for it to pick a percentage. for example a number of $6000 that is quarterly would be 5%. What is the formula for that?

By: Taylor

130 thoughts on “Vlookup or if

Comments are closed.