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!

Formula for calculating whole lengths
 

Hi,

Am Thu, 16 Apr 2015 08:15:46 -0700 (PDT) schrieb
:

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.

your length in A1. Then try:
=INT(A1/300)&" a 300 mm "&IF(MOD(A1,300)0,MOD(A1,300)/100&" a 100 mm","")


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional

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

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à ...