Home |
Search |
Today's Posts |
#1
|
|||
|
|||
logical test - within a range
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? |
#2
|
|||
|
|||
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 "esslingerdav" wrote: 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? |
#3
|
|||
|
|||
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. "esslingerdav" wrote: 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? |
#4
|
|||
|
|||
Have a look in HELP index for AND . Then mix with an IF function.
=and(if -- Don Guillett SalesAid Software "esslingerdav" wrote in message ... 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? |
#5
|
|||
|
|||
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(a1100,a1<500),funtion1,funtion2) hope this helps "esslingerdav" wrote: 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. "esslingerdav" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
range names | Excel Worksheet Functions | |||
Defined range difficulty | Excel Discussion (Misc queries) | |||
named range refers to: in a chart | Excel Discussion (Misc queries) | |||
range names | Excel Worksheet Functions | |||
range name | Excel Worksheet Functions |