Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to calculate numbers upwards to the nearest 300 and then to group
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to calculate numbers upwards to the nearest 300 and then to group
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to calculate numbers upwards to the nearest 300 and then to group
Hi
Try this for your first formula, assuming your worksheet is with headers and it start on row 2 =CEILING(B2,100) On your 2nd formula, I don't undertsand. Do you want a count for all same length quantites and sum these together? I need you to provide an example on how and where your data are. Where will be the results you want. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to calculate numbers upwards to the nearest 300 and then to gr
is it possible that i can send you example of work sheet this way will be
quicker "xlm" wrote: Hi Try this for your first formula, assuming your worksheet is with headers and it start on row 2 =CEILING(B2,100) On your 2nd formula, I don't undertsand. Do you want a count for all same length quantites and sum these together? I need you to provide an example on how and where your data are. Where will be the results you want. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to calculate numbers upwards to the nearest 300 and then to gr
for the benefit of others, pls keep it in the newsgroup.
You may also upload your file in one of the free file hosting eg http://freefilehosting.net -- If this posting was helpful, please click on the Yes button Thank You cheers, "jacob" wrote: is it possible that i can send you example of work sheet this way will be quicker "xlm" wrote: Hi Try this for your first formula, assuming your worksheet is with headers and it start on row 2 =CEILING(B2,100) On your 2nd formula, I don't undertsand. Do you want a count for all same length quantites and sum these together? I need you to provide an example on how and where your data are. Where will be the results you want. HTH -- If this posting was helpful, please click on the Yes button Thank You cheers, "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I round a column of numbers to the nearest | Excel Worksheet Functions | |||
How can you round numbers to the nearest quarter (i.e. .63=.75) | Excel Worksheet Functions | |||
How can I convert a group of numbers to a group of letters? | Excel Worksheet Functions | |||
Can you round up numbers to the nearest multiple of ten? | Excel Worksheet Functions | |||
Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions |