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?