"kimkay" wrote:
.. Max -- I tweaked your suggestion more and got it to work!
Here's the formula that did the trick:
=IF(OR(H3={0,1,2}),0,IF(AND(H3=3,H3<=25),(100*H3) ,2500))
Many thanks!! This saved me a ton of work and a lot of head-scratching.

Glad to hear that, Kim !
Pl disregard my response in the other branch ..
(didn't know you had a message for me over here <g)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---