If range formula

[Sparda142]

Hello,

How can i change the formula below to use a range for greater than/less than. I'm trying to say if k137 is equal to or greater than 6.5 but equal to or less than 0.5.

=IF(K137>5,IF(AND(D152>=$L$12,D152<=$M$12),$J$12,"-"), "-")

 

[steve the fish]

In exactly the same way as you have done for D152, you use an AND.

Edit. Talking rubbish.

You use an OR not an AND. Same process though.

 

[Sparda142]

In exactly the same way as you have done for D152, you use an AND.

Edit. Talking rubbish.

You use an OR not an AND. Same process though.

so the formula should be =IF(OR(K137>=6.5,0.5<=K137),IF(AND(D152>=$L$12,D152<=$M$12),$J$12,"-"), "-") ???

 

[steve the fish]

The OR like that would be:

OR(K137>=6.5,0.5>=K137)