You example sounds wrong, since 2100 mm is evenly divisble by 300 mm. But as
for what you ask,

=IF(A25400,"Too big",ROUNDUP(A2/300,0)*3005400)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"jacob" wrote:

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