Does anyone know how I can round a number up to a specific set of
numbers.

I need to round a number to the nearest of the following numbers:
250
350
450
550
650
750
850
950
1050
1150
1250
...
...
etc

The numbers above are in a range B3:AC3.

Eg 1: 260 becomes 350
Eg 2: 700 becomes 750

Any ideas?

Bradles


--
bradles
------------------------------------------------------------------------
bradles's Profile: http://www.excelforum.com/member.php...nfo&userid=998
View this thread: http://www.excelforum.com/showthread...hreadid=569322