I should have been more specific. I am trying to create a sheet to track
sales totals and margins based on a point system. I would want it to assign
the highest number from column C that applies. So it would probably have to
go backwards. eg. if not 2000 @ 40, then 2000 @ 35, then 2000 @ 30 ect.

"Ron Rosenfeld" wrote:

On Thu, 10 Feb 2005 07:15:04 -0800, "Chris"
wrote:

I am trying to create a formula in a spread sheet, but I can't seem to figure
it out. I don't even know if its possible but I want to return a value in
each cell c based on the following paramaters for A & B. Is there anyone who
can help point me in the right direction? I would be eternally grateful.
a b c
500 50% 1
750 50% 2
1000 35% 2
1000 50% 4
2000 30% 2
2000 35% 3
2000 40% 5

The example and description you give are not exclusive. What are the rules if
a pair of parameters fit into more than one row?


--ron