View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
[email protected] nigel@brilliantlighting.co.uk is offline
external usenet poster
 
Posts: 1
Default Formula for calculating whole lengths

I sell items in lengths of 300mm & 100mm only.

I am trying to write a formula that will look at a whole number, say for example 2800mm, and get the number of 300mm units required, and then add the remainder on in 100mm units (i.e. in this case 9 @ 300 and 1 @ 100). Obviously if its 200mm or below it will end up as 2 No 100mm units.

This is for any whole length from 100 to 3000.

Any help appreciated!