Hi All,

I am very new at Excell and could use some help. Is it possible to set at max number for a cell and have anything over that set number go to a different cell? An example would be as follows.

Cell A1 is set at 50. If I type in 67, A1 would stay at 50 and the other 17 would go to a cell of my choice.

and

Cell A1 is set at 50. Anything less than 50 would read that value. Say 35 just stays 35.

Thanks