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.

Hi

something along the lines of

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

Cheers
JulieD

"laurieevan" wrote in message
...
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.

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

"laurieevan" wrote:

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.

you're welcome and thanks for the feedback

"laurieevan" wrote in message
...
Thank you for your assistance. This is just what I needed. The problem
is
solved. Thanks again.

"laurieevan" wrote:

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.