Hi,

its jacob you posted the answer for me i realized i botched this up so i am
emailing to you what i really need

as you understand firstly timber in lengths are purchased in 300mm
calcualtions example 300, 600, and so on

Now i am a builder and i am trying to set up a work sheet to calcuate the
architraves around many windows in a house these are the timbers that cover
around a window internally


So in saying this i need two sets of formulas


Formula 1. to calculate each piece upwards to the nearest 300mm for example
if it is 2048mm then should be 2100mm and so on


Formula 2. once i have many windows which would have 4 pieces of wood to
each i am in need to then quickly calculate the the totall quantities to
place the order to the timber suppliers


ie/ i could have 12@ 2400 32@ 1200 and so on so i need a formula which would
clacuate all the same lenghts and quantities of length


"Luke M" wrote:

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