Formula to determine if a number is BETWEEN set -50 and 50

[Mister H]

Hi All:

I am wondering if there is an easy way to determine if the number (in Column D) is between -50.00 and 50.00

Once I get the formula I will try and implement it in one of the codes I am currently using.

THANKS,
Mark

 

[pedie]

Something like this..
'=IF(AND(D5<50,D5>-50),"Yes","No")

 

[Mister H]

THANKS Pedie:

That seems to work in most cases but can this formula be modified so that if the number in D5 ( in this example) is NOT between -50.00 and 50.00 then leave the cell containing the formula blank? ALSO if D5 is blank then I also need the cell containing the formula to be blank.

Currently when I use your formula I get the answer YES when there is no Value in D.

Hope this makes sense.

Bye 4 Now,
Mark

 

[Peter_SSs]

Which result do you want if the value in column D is exactly equal to 50 or -50?

 

[Mister H]

Hi Peter_SSs

If the value is equal then it can say Yes. What I actually want to happen is that if the number in D is Blank, and Greater then 50.00 or Less then -50.00 then the answer is ""

If the value is equal or between -50.00 and 50.00 then I want the answer to be "DO NOT review"

I figured I could play around and get the final tweak.

Thanks,
Mark

 

[Peter_SSs]

Try

=IF(OR(D2="",MEDIAN(D2,-50,50)<>D2),"","DO NOT review")

 

[Mister H]

Hi Peter_SSs:

THANKS a BUNCH

That seems to work perfectly. Your help and expertise is GREATLY Appreciated.

Have a GREAT day,
Mark