Let me try this again and be more complete. Maybe someone can help me. I
want to be able to enter information of sales and margin for certain orders
into a & b on a spreadsheet and then have excel return a certain number into
c based on the following chart. Which I can then add up at the end of the
month for each sales person. Unfortunately I am not an expert in excel. Is
this a chart I need to reference or can it be entered as a formula and how
would I do it to get the corret result? Is excel even capable of doing this?

sales margin points

$500-749 =50% 1
$750-999 =50% 2
$1000-1999 35-49% 2
$1000-1999 =50% 4
$2000-4999 =30-34% 2
$2000-4999 =35-39% 3
$2000-4999 =40% 5
$5000-9999 =26-29% 8
$5000-9999 =30-34% 12
$5000-9999 =35% 16
$10,000 + =23-27% 12
$10,000 + =28-31% 16
$10,000 + =32% 24

Eg. we enter the information in a & b and the worksheet puts the number in
c. then I can sum up the total of c. as in this example below.
a b c
sales margin points
1243 37 2
2457 44 5
556 52 1

Anyone who could help with an answer, I would greatly appreciate it.