Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for calculating whole lengths
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for calculating whole lengths
Hi,
Am Thu, 16 Apr 2015 17:27:28 +0200 schrieb Claus Busch: =INT(A1/300)&" a 300 mm "&IF(MOD(A1,300)0,MOD(A1,300)/100&" a 100 mm","") better try: =INT(A1/300)&" à 300 mm "&IF(MOD(A1,300)100,INT(MOD(A1,300)/100)&" à 100 mm","") Regards Claus B. -- Vista Ultimate / Windows7 Office 2007 Ultimate / 2010 Professional |
#4
|
|||
|
|||
Mã giảm giá Lazada Voucher [/color]Lazada, Zalora 2 triệu VND, mã giảm giá, phiếu giảm giá, voucher giảm giá Lazada, Zalora với số lượng lớn, duy nhất chỉ có tại BizzaViet. Đy là ...
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |