Possibly too late now but does:

=CEILING(A1-50,100)+50

do what you want?

--
HTH

Sandy
In Perth, the ancient capital of Scotland


with @tiscali.co.uk


"bradles" wrote in
message ...

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