Thread: how do i set up formula to calculate to the neares 300 number
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Jacob is offline
external usenet poster
  
Posts: 20
Default 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
Reply With QuoteReply With Quote