How can I auto fill a column by a stepped amount until a variable max value is exceeded?

Your suggestion worked perfectly for my application.
The nested IF function is quite clever.
It reminded me of some of the programming I used to do decades ago.
Thanks again.

You're welcome.

Thanks for marking the thread as SOLVED, and for the rep.

Pete