Hi
sorry, my fault. Should have tested this. re-order the formula as follows:
=MAX(IF(A12000,75,IF(A11500,50,IF(A11000,25,0)) ),IF(B10.06,75,IF(B10.05,50,IF(B10.04,25,0))))

--
Regards
Frank Kabel
Frankfurt, Germany
"Brad" schrieb im Newsbeitrag
...
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?