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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Thank you for your assistance. This is just what I needed. The problem is
solved. Thanks again.
 
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.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

return a value based on a range 3
With F1 value, look at A, if match or partial match return B 5
Lookup returning wrong results 0
How to subtract a number from a Mergefield? 0
SUMIF within a range 11
Return an array of data based on range of date 3
Get a row number of range where a value is between minimum and max 2
Access Macro Repeat Expression using value of a field in table 0

Back
Top