Look in the help index for ROUND
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Mick B" wrote in message
...
Hi, I need to round up a sheet of figures that will do the following: if a
figure is between £4.50 and £4.99, the figure will be rounded up to £5.00,
or
if between £4.00 and £4.49, then rounded down to £4.00.

Any clues please?