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.