Just for another alternative:

=0.2*(ABS(0.5-K2)<0.49) + 0.4*(ABS(5.5-K2)<4.5)

In article .com,
"Rolo" wrote:

On Feb 9, 3:45 pm, polardude1983
wrote:
basically what i want to do is if Cell number H2 is greater then 0.01 and
less then 0.99 then H2 equals 0.20

but if H2 is greater then 1.00 and less then 9.99 then H2 equals 0.40
can anybody help me with this? i have this so far

=IF(AND(H2<0.99,H20.01),"0.20","Invalid")

What about this one formula:

=IF(AND(K20.01,K2<0.99),0.2,IF(AND(K21,K2<10),0. 4,"Invalid"))