Want to return a value based on a whether a number is within a ra.

[laurieevan]

Want to return a value based on a whether a number is within a range of
numbers using the IF function. Can someone please give me the correct syntax.

 

[JulieD]

Hi

something along the lines of

=IF(AND(A1>=1,A1<=10),"yes","no")

Cheers
JulieD

 

[laurieevan]

Thank you for your assistance. This is just what I needed. The problem is
solved. Thanks again.

 

[JulieD]

you're welcome and thanks for the feedback

Thank you for your assistance. This is just what I needed. The problem
is
solved. Thanks again.