Assuming boundary numbers in A1 and A2 and he third number in A3 then
maybe in another cell:

=IF(AND(A3=MIN(A1:A2),A3<=MAX(A1:A2)),"","Out of bounds!")

Hope this is the kind of thing you wanted.


rocks256 wrote:

I want to put two numbers in separate cell. Then I would like to see if a
third cell
stays between the first two cells. If it does not, then I would like to be
notified,
(warning) in some way.
p.s. I am NOT an excel beginner. I use formulas all the time.