Help with if/and formula
.... assuming you want the FALSE value to return 100*H3.
Almost but not quite, Dave! I wanted the true value to return the 100*H3,
and the false value was working for any number greater than 25 in H3, I was
just having trouble with those pesky number less than 3.
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.
Kim
|