On Thu, 10 Feb 2005 13:37:04 -0800, "Chris"
wrote:

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.


OK, I think I understand.

If you label your three columns of data: a, b and points, then the following
*array-entered* formula should do what you describe:

=MAX((Salesa)*(Marginb)*points)

To *array-enter* a formula, after typing/pasting it into a cell, instead of
just hitting <enter, hold down <ctrl<shift while hitting <enter. XL will
place braces {...} around the formula.

One caveat: In your original post you used symbology implying that Sales and
Margin had to be GREATER than certain values. That means that if you had Sales
of exactly 500, and Margin of exactly 50%, the result of the above formula will
be ZERO, not ONE. If that is not what you wish, you may need to change some
values, or change the comparison operators in the formula from "" (Greater
than) to "=" (Greater than or equal to).


--ron