Greetings,

As always, thanks in advance for any and all replies.

In our company, we use a lot of ticket rolls. These rolls come in multiples of 2000. For example if a ticket sequence starts at #1, the last ticket on the roll will be #2000. If a ticket sequence starts at #122001, the last ticket on that roll will be #124000.

I'm looking for a formula that, given a ticket number in the roll, will return the last number on the roll.

If it helps, since rolls are always in multiples of 2,000, note that number will also be the first number evenly divisible by 2,000.

So any ticket number entered from 1 to 2000 will return 2000.
Any ticket number entered from 2001 to 4000 will return 4000.
Ticket number 12349 will return 14000. Ticket number 54780 will return 60000.

Etc.