logical test - within a range

G

Guest

Is it possible to do a logical test on a cell that will determine whether the
number falls within a range of numbers then return a yes or no function?
 
G

Guest

If you are are talking about a range that exists on your worksheet then, if
a1:a7 was your range and b1 was the number you were checking for this might
work

=COUNTIF(A1:A7,B1)>0
 
G

Guest

Clarification: I am talking about a number in one cell. Can I determine it
to fall between say 100 and 500. If yes - return a function, if no - return
a different function.
 
G

Guest

As an example if you were to enter 200 in a1, a1 would return the results of
a function? You could through a macro on the change event.

if you want a diffent cell to return the results of the value in a1 then as
an example in
b1 you could have
=if(and(a1>100,a1<500),funtion1,funtion2)

hope this helps
 

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

Ms Excel Multiple Logical Test Function 0
function to populate a cell where formula is NOT located 6
Test if CELL is in RANGE 12
If a range contains 1
If Statement with Two Different Logical Test 16
Can I use 'CONTAINS' in an IF Logical Test? 2
Format within a Function 1
Return result of IF logical test in a different cell 1

Top