I'm not sure this is working right. What I want to do is track orders
entered per sales person, and award a cetain number of points to each
quailifiying order which will then be added up at the end of each month. the
points will be used for a bonus program. there are actually 2 more levels
5000, & 10000 with 3 different margin levels for each of those also, but I
left that off in the interest of space.
I was hoping excel could compare the 2 pieces of data entered and return a
single number in the c column which could then be added up. Unfortunately I
am not an expert in Excel.

"Bernd Plumhoff" wrote:

Enter following values/formula into cells A1:C8, for
example:
2001 0.31 =MAX((A1A2:A8)*(B1B2:B8)*C2:C8)
500 0.5 1
750 0.5 2
1000 0.35 2
1000 0.5 4
2000 0.3 2
2000 0.35 3
2000 0.4 5

Formula in C1 has to be entered as array formula (hit
CTRL+SHIFT+ENTER, not only ENTER).

Just a hint: Maybe you want to use = instead of ?!

HTH,
Bernd