On Fri, 19 Dec 2008 22:05:01 -0800, jacob
wrote:

Hi,

its jacob i need formulas or macros which ever to do the following

firstly timber in lengths are purchased in 300mm calcualtions example 300,
600, 900, 1200 and so on up to 5.400 mm which is 5.4 meters

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 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 lengths to place order


Thank You jacob


Assuming your lengths are in column A starting on row 1.
For formula 1 try this in cell B1 and copy down as far as needed:

=CEILING(A1,300)

Now column B should list the standard lenghts needed.
In column C put 300,600,900,1200, aso up to the longest standard
length.

In cell D1 put the following:

=COUNTIF(B$1:B$100,C1)

Copy it down for as many rows that you have standard lengths.

Column D should now hold the number you need for each standard length.

Hope this helps / Lars-Åke