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