I am in the process of trying to create a pinning calculator for locksmithing, and I'm running into an issue where I can't have the number exceed single digits, so I'm wanting to have it reset to 0 or 1 based on if the next number would be.
Here's an example of what I'm trying to do.
2 3 4 5 6 7 8
2 3 4 5 6 7 0
2 3 4 5 6 7 2
2 3 4 5 6 7 4
2 3 4 5 6 7 6
What it's currently trying to do:
2 3 4 5 6 7 8
2 3 4 5 6 7 10
2 3 4 5 6 7 12
2 3 4 5 6 7 14
Is there a formula to keep that from happening, or will I just simply have to fix any numbers that exceed single digits?
I'm fine if there's a setting that will apply this rule to an entire sheet, as long as it doesn't affect separate sheets.
Right now, I'm just using "Conditional formatting" to flag any number greater than 9, so it's made obvious what cells are exceeding that limit.
Bookmarks