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.
Bookmarks