Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up formula to calculate to the neares 300 number
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up formula to calculate to the neares 300 number
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up formula to calculate to the neares 300 number
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 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) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up formula to calculate to the neares 300 number
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) -- Biff Microsoft Excel MVP "jacob" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up formula to calculate to the neares 300 number
Argh, I erred in my copy/paste.
Should be =IF(A25400,"Too big",CEILING(A2,300)) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up formula to calculate to the neares 300 number
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i set up formula to calculate to the neares 300 number
can i send to a email showing the spread sheet
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula to calculate number of hours worked in a day | Excel Discussion (Misc queries) | |||
Formula to calculate number of days between Dates | Excel Worksheet Functions | |||
Need a formula to calculate the number of months to pay off a loan | Excel Discussion (Misc queries) | |||
Using formula to calculate a number. | Excel Worksheet Functions | |||
Looking for function or formula to calculate number that is revers | Excel Worksheet Functions |