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"))

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"))

I know that the problem originates in the OP's description because he does
not specify what should happen if K2=1. As written your formula returns 0,
perhaps either:

=0.2*(ABS(0.5-K2)<=0.5) + 0.4*(ABS(5.5-K2)<4.5)
to return 0.2 for K2=1 or
=0.2*(ABS(0.5-K2)<0.49) + 0.4*(ABS(5.5-K2)<=4.5)
to return 0.4 for K2=1


--
Regards,

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk


"JE McGimpsey" wrote in message
...
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"))