View Single Post
 
Old 06-21-2023, 08:52 AM
ExcelGuy362 ExcelGuy362 is offline Windows 10 Office 2019
Novice
 
Join Date: Jun 2023
Posts: 2
ExcelGuy362 is on a distinguished road
Default Formula for Excel?

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.
Reply With Quote