< > Formula Help Please

[rockyw]

I'm trying to make a chart that will use condisional formating. What would be the formula to look at B2 and return the value if it's between 70 and 90? I just can't make it work. Thanks for any help.

 

[Jonmo1]

perhaps

=IF(MEDIAN(70,B2,90)=B2,B2,"")

 

[VoG]

Try

=AND(B2>=70,B2<=90)

 

[rockyw]

Thanks for the replys. Both of these give me a True or False? I would like to return the value if it's between 70 and 90 or nothing. Thanks

 

[VoG]

Try

=IF(AND(B2>=70,B2<=90),B2,"")

 

[rockyw]

Thanks what I was trying to do, sorry if I was not clear the first time. Thanks for the help