From: fazz on
Hello - how do i round a number up to the nearest 50p
From: T. Valko on
Maybe this...

A1 = some positive number

=CEILING(A1,50)

--
Biff
Microsoft Excel MVP


"fazz" <fazz(a)discussions.microsoft.com> wrote in message
news:825ECDAC-5284-4D43-9052-4BAC6AB7CA57(a)microsoft.com...
> Hello - how do i round a number up to the nearest 50p