"kimkay" wrote:
Clarification: the question above should read as follows...
I can't figure out how to write the formula the way it really needs to be,
which is basically that I want it to return the value of "100*H3" OR "2500"
only if the value in column H is BETWEEN 3 and 25 -- if the value is 0, 1, or
2 I need a zero or a null.

2nd guess, maybe you mean something like ..:
=IF(OR(H3={0,1,2}),0,IF(AND(H3=3,H3<=25),MAX(2500 ,100*H3),"H3 is
out-of-range"))

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---