floor/ceiling alternative

Jo · Oct 27, 2003

Hi
I need to round a number to the nearest 20, but unlike
floor or ceiling I want to round up or down.
eg. 29 =20 and 33 =40.
If there is not a worksheet function to do this may be
someone could suggest some VBA code.
Thanks
Jo

Bob Phillips · Oct 27, 2003

Jo,

Worksheet functions do it simply enough. Try

=ROUND(A1/20,0)*20

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)