View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
kimkay
 
Posts: n/a
Default 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