Wouldn't you want to round up to the next multiple of 300? If you need a
piece 149mm long rounding to the *nearest* 300 would round 149 down to 0.

Also, 2100 is a multiple of 300 so why would you want to round that up to
2400?

Try this to round up to a multiple of 300:

=CEILING(A1,300)

--
Biff
Microsoft Excel MVP


"jacob" wrote in message
...
i need to calculate timber lengths at 300mm for example if a piece of
timber
is 2100mm i need it to automatically calculate to 2400mm becouse all
timber
is purchased in 300mm lengths
300, 600,900,1200,1500 and so on up to 5.4 meters

then i need to calculate how many pieces of these lenghts to place order
these will be many