I have numbers in a column that are all divisible equally by 250. I need to convert these numbers into a number that is divisible equally by 400 but that is never lower than the original number.
For example the numbers on the left should convert to the numbers on the right.
250 400
500 800
750 800
1000 1200
1250 1600
1500 1600
I have racked my brain and cannot figure out this formula.
Thanks for any help.
Eric
For example the numbers on the left should convert to the numbers on the right.
250 400
500 800
750 800
1000 1200
1250 1600
1500 1600
I have racked my brain and cannot figure out this formula.
Thanks for any help.
Eric
