Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lengths of LISTS | Excel Discussion (Misc queries) | |||
Formula for Angle of triangle from opposite and adjacent lengths | Excel Worksheet Functions | |||
Economical grouping of lengths out of much longer lengths | Excel Worksheet Functions | |||
Chart lengths | Charts and Charting in Excel | |||
forms and column lengths | Excel Discussion (Misc queries) |