"kimkay" wrote:
I need help with a simple task, but I'm stumped! The formula below works,
except when the value in colmn H is 0. 1. or 2. Unfortunately, those values
can be in that column and 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
"2500" only if the the value in column H is BETWEEN 3 and 25. Please help!!!

=IF(AND(H3=3,H3<=25),100*H3,2500)

Maybe just flip the condition if TRUE/FALSE around ?, viz:
=IF(AND(H3=3,H3<=25),2500,100*H3)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---