¥H½cªº°â»ùpºâ¥X¨ä¥L«¶qªº°â»ù¤½¦¡¦p¦ó¤U
- ©«¤l
- 207
- ¥DÃD
- 61
- ºëµØ
- 0
- ¿n¤À
- 270
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-20
- ³Ì«áµn¿ý
- 2023-6-25
|
¥H½cªº°â»ùpºâ¥X¨ä¥L«¶qªº°â»ù¤½¦¡¦p¦ó¤U
|
|
|
|
|
|
- ©«¤l
- 207
- ¥DÃD
- 61
- ºëµØ
- 0
- ¿n¤À
- 270
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-20
- ³Ì«áµn¿ý
- 2023-6-25
|
¦^´_ 2# Hsieh
«~¦W °â»ù µª®×
¨§Ãþ(22.68Kg/Ctn) 450.00
¨§Ãþ(Kg) 19.84
¨§Ãþ(600G/Pk) 0.00 11.90
¨§Ãþ(500G/Pk) 0.00 9.92
¨§Ãþ(300G/Pk) 0.00 5.95
¨§Ãþ(200G/Pk) 0.00 3.97
¨§Ãþ(150G/Pk) 0.00 2.98
¨§Ãþ(112.5G/Pk) 0.00 2.23
¨§Ãþ(100G/Pk) 0.00 1.98
¨§Ãþ(75G/Pk) 0.00 1.49
¨§Ãþ(50G/Pk) 0.00 0.99
¨§Ãþ(37.5G/Pk) 0.00 0.74
¨§Ãþ(G) 0.00 0.02 |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
B6 =MID(A6,4,FIND("G",A6)-4)/1000*B$5
¤U©Ô |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 207
- ¥DÃD
- 61
- ºëµØ
- 0
- ¿n¤À
- 270
- ÂI¦W
- 0
- §@·~¨t²Î
- Vista
- ³nÅ骩¥»
- office2003
- ¾\ŪÅv
- 20
- ©Ê§O
- ¤k
- µù¥U®É¶¡
- 2011-3-20
- ³Ì«áµn¿ý
- 2023-6-25
|
¦^´_ 4# ML089
"G"ªºµª®×¨SÅã¥Ü¥X¨Ó? |
|
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 5# Qin
(G) n§ï¬° (1G) ¡A¸ê®Æ®æ¦¡¤~¯à¤@P©Ê¡A
¤£¤@P©Êªº¸ê®Æ»Ýn¼W¥[ÃB¥~§PÂ_¡AY¦³»Ýn¥i¥H¥t¥[¨Ì§PÂ_´N¥i
«Øijn¾i¦¨¸ê®Æ®æ¦¡¤~¯à¤@P©Êªº²ßºD¸û¦n |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|
- ©«¤l
- 2025
- ¥DÃD
- 13
- ºëµØ
- 0
- ¿n¤À
- 2053
- ÂI¦W
- 0
- §@·~¨t²Î
- WIN7
- ³nÅ骩¥»
- Office2007
- ¾\ŪÅv
- 100
- ©Ê§O
- ¨k
- ¨Ó¦Û
- ¥x¥_¥«
- µù¥U®É¶¡
- 2011-3-2
- ³Ì«áµn¿ý
- 2024-3-14
|
¦^´_ 5# Qin
(G) §ï¬° (1G)
(Kg) §ï¬° (1Kg)
B4 =450/22680*(-LOOKUP(,-MID(A4,FIND("(",A4)+1,ROW($1:$9)))*1000^COUNTIF(A4,"*Kg*"))
¤U©Ô½Æ»s¤½¦¡
450/22680 pºâ¥X¨CGªº³æ»ù¡Aª½±µ¶ñ¼Æ¦r¤]¥i¥H
(-LOOKUP(,-MID(A4,FIND("(",A4)+1,ROW($1:$9)))*1000^COUNTIF(A4,"*Kg*")) pºâ¦³´XG |
|
{...} ªí¥Ü»Ýn¥Î CTRL+SHIFT+ENTER ¤TÁä¿é¤J¤½¦¡
|
|
|
|
|