# “Weight”

#### Marwan69

##### New Member
Hi,

i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my formula also convers ml & g which I don’t want to be touched. For example: Any smaller unit/weight i want my formula to ignore. How can I incorporate this in my formula?

Many thanks.

Last edited:

### Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

#### KRice

##### Well-known Member
I'm not sure how your sheet is organized, but if you are trying to operate on one column by multiplying or dividing by a conversion factor, just use 1 for mL to mL.

#### Marwan69

##### New Member
I tried but because my formula conver every kg and liter into the smallest weight, it also does the same with ie: 700ml. Which as you can see here it doesn’t need to be converted. The same with grams.

#### KRice

##### Well-known Member
You'll have to provide more detail about your worksheet. I don't understand the issue that you are encountering. The best option would be to post a small sample using XL2BB.

Sure

#### Marwan69

##### New Member
 B1​ C1​ D1​ E1​ A2​ Unit 1 kg L ml A3​ Weight 16 1 0.700 A4​ Qty 65 1 1 A5​ P 1,040 57 40 A6​ T.P 0.07 0.06 57.14 C6 C5/C3/1000 D6 D5/D3/1000 E6 E5/E3

E5/E3 formula is not consistent with the the other two formulas. So I need always to edit for each weight that contains (ml) which is exhausted task for a long excel sheet.

#### KRice

##### Well-known Member
I don't understand what you are trying to show. It appears that you want units only in the top row? (so C1 should be "kg" not "1 kg"). Are you listing many units across row 1? Then in row 2, it appears that you've labeled the left side of the row "Weight", but when I look to the right of that label, I see "16" under the "kg" column, 1 under the "L" column, and 0.700 under the "mL" column. None of those represent a weight quantity. Could you clarify that and what is meant by "P" and "T.P" and "Quantity"? Here is an attempt to convert your table above into XL2BB format. You can copy this (click the clipboard icon in the upper left at the intersection of rows/columns) to make a copy. Ideally, you should install the XL2BB add-in so that your actual content could be uploaded.
Book1
ABCDE
1Unit1 kgLmL
2Weight1610.7
3Qty6511
4P10405740
5T.P0.070.0657.14
6
1.07692E-06
0.00006
57.14
Sheet3
Cell Formulas
RangeFormula
C6:D6C6=C5/C3/1000
E6E6=E5/E3

#### Marwan69

##### New Member
I have installed it but did't know how to use it. My appologies!
Ok got it!

Last edited:

#### Marwan69

##### New Member
Book1
ABCD
1Coffee BeansMonin Blue Ocean syrupMonin Pomergranate syrup Monin Vanella syrup
216 kg1 L700 ml700 ml
31111
4
16
1
11
5
65
57
57
57
6
1,040
57
57
57
7
1,092
60
60
60
8
0.07
0.06
0.09
0.09
Sheet1
Cell Formulas
RangeFormula
A4:B4A4=A3*A2
A5A5=65
B5:D5B5=57
A6A6=A5*A2
B6:D6B6=B5*B3
A7:D7A7=A6*1.05
A8A8=A7/A4/1000
B8B8=B7/1000
C8:D8C8=C7/C2

#### KRice

##### Well-known Member
Good...I see you have the add-in working. If we focus on column A only, what do the values represent in rows 5,6,7,and 8? Are you converting 16 kg into some other units there?