Increment by 1 if the total equals 10,000, not more, not less, but equal to
10,000. The nature of the beast is that the typist would only enter a value
that is greater than 9,999 but never over 10k. I hope this is what you need...

"Gary''s Student" wrote:

Do you want the increment only when it changes from below 10K to above 10K,
or anytime is is above 10K?
--
Gary's Student


"Workshops" wrote:

How do I increment, automatically, a cell by 1 if a condition is met? If one
of my cells reaches 10k I want another cell to increment by 1. Can anyone
help me if this function can be done?
Thank you, Ron