A third possibility:

=MAX((A1{2000,1500,1000})*{75,50,25},(B1{0.06,0. 05,0.04})*{75,50,25})

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Brad" skrev i en meddelelse
...
I would like to have a formula that would return a value based on the
following criteria

A11000 or B14% return a value of 25
A11500 or B15% return a value of 50
A12000 or B16% return a value of 75

Here's the tricky part. I always want it to return the higher value. In
other words if the value in A1 is 1100 but the value in B1 is 5.5% then I
want it to return a value of 50.