Thank Frank

I used this fomula and it seems to be working for picking up the first
function but not the second or third greater than. For example (my columns
are acutally I and J) I have a value of $942.99 in I and a value of 5% in J
and the formula returned a value of 25 not 50. Any ideas why?

"Frank Kabel" wrote:

Hi
one way:
=MAX(IF(A11000,25,IF(A11500,50,IF(A12000,75,0)) ),IF(B10.04,25,IF(B10.05,50,IF(B10.06,75,0))))

--
Regards
Frank Kabel
Frankfurt, Germany

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.