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

laurieevan · Feb 23, 2005

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 · Feb 23, 2005

Hi

something along the lines of

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

Cheers
JulieD

laurieevan · Feb 23, 2005

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

JulieD · Feb 24, 2005

you're welcome and thanks for the feedback

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