There are probably smarter ways

=MAX(VLOOKUP(A1,{0,0,0;1001,0.041,25;1501,0.051,50 ;2001,0.061,75},3),VLOOKUP(B1,{0,0;0.041,25;0.051, 50;0.061,75},2))

Regards,

Peo Sjoblom

"Brad" wrote:

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.