Hi. I keep forgetting how to achieve the desired result in Excel.

Say that I want a Cell (Let’s say, B1) to contain an initial value of 31, and as I add a number in A1, it decrements B1's value by 1, and the very minimum number is 1, so, if I put an outrageously large number (10,000), for instance, B1 still will have a value of 1.

I have found not only an answer, but, an improved version of the answer! If you put =MAX(MIN(A1-1,1),3-A1) in B1, it's going to have a 3 in B1. The improvement is the fact that I accounted for negative values. So, if you put -359, for instance, it's going to result in B1 having a value of 362.