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)

Thanks...