how do i set up formula to calculate to the neares 300 number

[jacob]

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

 

[Luke M]

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

=IF(A2>5400,"Too big",ROUNDUP(A2/300,0)*300>5400)

 

[Harlan Grove]

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

Uh, 2100 is an integer multiple of 300, as in 7 * 300 = 2100. If you
really need 2400mm in this instance, you need to provide more details,
e.g., if you needed a length of 2090mm, would 2100mm suffice? In other
words, how close would a length shorter than 2100 have to be to be
able to purchase a 2100mm length rather than a 2400mm length.

Or was 2100mm a typo, and you meant to type 2200mm?

If the latter, then for a 2200mm length, the formula would be

=300*ROUNDUP(2200/300,0)

 

[T. Valko]

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)

 

[Luke M]

Argh, I erred in my copy/paste.

Should be
=IF(A2>5400,"Too big",CEILING(A2,300))

 

[jacob]

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

 

[jacob]

can i send to a email showing the spread sheet

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

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

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