Excel formula?

[HepKnosp]

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.

[HansV]

Welcome to Eileen's Lounge!

You can use the MAX function for this:

=MAX(31-A1, 1)

Remark: if you use comma as decimal separator, use ; in the formula:

=MAX(31-A1; 1)

[rory]

Except change the 0 at the end to 1 if that's the minimum value you want. ;)

[HansV]

Of course!