µù¥U
µn¿ý
º¶
½×¾Âª©³W
¸T¤î¦Cªí
»¡©ú
¦a¹Ï
¼Æ¦ì®Ñ»
¨p¤H®ø®§ (0)
¤½¦@®ø®§ (0)
½×¾Â¥ô°È (0)
¨t²Î®ø®§ (0)
¦n¤Í®ø®§ (0)
©«¤l®ø®§ (0)
³Â»¶®a±Ú°Q½×ª©ª©
»
Excel£¸¯ë°Ï
» QUOTIENT
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
µo©«
[µo°Ý]
QUOTIENT
rouber590324
µoµu®ø®§
¥[¬°¦n¤Í
rouber590324
·í«eÂ÷½u
UID
18546
©«¤l
561
¥DÃD
160
ºëµØ
0
¿n¤À
725
ª÷¿ú
725
ÂI¦W
0
§@·~¨t²Î
WINDOWS
³nÅ骩¥»
xp
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
®ç¶é
¦b½u®É¶¡
557 ¤p®É
µù¥U®É¶¡
2014-9-10
³Ì«áµn¿ý
2024-8-7
°ª¤¤¥Í
©«¤l
561
¥DÃD
160
ºëµØ
0
¿n¤À
725
ÂI¦W
0
§@·~¨t²Î
WINDOWS
³nÅ骩¥»
xp
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
®ç¶é
µù¥U®É¶¡
2014-9-10
³Ì«áµn¿ý
2024-8-7
1
#
¸õÂà¨ì
»
˧Ǭݩ«
¥´¦L
¦rÅé¤j¤p:
t
T
µoªí©ó 2016-3-14 08:28
|
¥u¬Ý¸Ó§@ªÌ
[µo°Ý]
QUOTIENT
DEAR ALL ¤j¤j
1.¨Ï¥Î¨ì QUOTIENT¨ç¼Æ ³æ¥X²{ #NAME? ¿ù»~
1.1¬d´M¤pÀ°¤â«á§iª¾¹Ï¤@
2.½Ð°Ý¦p¦ó °õ¦æµ{¦¡¥H¦w¸Ë¡u¤ÀªR¤u¨ã½c¡v? ÅýQUOTIENT¨ç¼Æ¥i¥¿±`¹B§@?
3.·Ð¤£§[½ç±Ð THANKS*10000
¹Ï¤@
¶Ç¦^¨â¼Æ¬Û°£©Ò±o¤§°Óªº¾ã¼Æ³¡¤À¡C³oÓ¨ç¼Æ¥i¥H¥Î¨Ó°£¥h¨â¼Æ¬Û°£µ²ªGªº¾l¼Æ³¡¤À¡C
¦pªGµLªk¨Ï¥Î¦¹¨ç¼Æ¡A¥B¶Ç¦^ #NAME? ¿ù»~¡A½Ð°õ¦æµ{¦¡¥H¦w¸Ë¡u¤ÀªR¤u¨ã½c¡v¡C
¼Ó¥D¼ö©«
«ü©w¸ê®Æ§¨¤º«D¤å¦rÀɦ۰ÊÂà´«¬°¤å¦rÀÉ°ÝÃD
½s¿è¿ù»~,¨Ï¥ÎªÌ¦Ûq§ÎºA©|¥¼©w¸q-°ÝÃD½Ð±Ð
«ü©wÀx¦s®æ½d³òÅܧ󩳦âÃC¦â°ÝÃD½Ð±Ð-VBA
VLOOKUP°ÝÃD½Ð±Ð
«ü©w¦r¤¸°ÝÃD½Ð±Ð
¸ê®Æ§¨¦Û°Ê¨Ìì«h§R°£ÀÉ®×°ÝÃD½Ð±Ð
µLªk¦C¦L°ÝÃD½Ð±Ð
SUM VBA¼gªk½Ð±Ð
¦hSHEET¤u§@ªí¸ê®Æ¶×¾ã°ÝÃD½Ð±Ð
קï¤é´Á°ÝÃD´M°Ý
¦¬ÂÃ
¤À¨É
ù
yen956
µoµu®ø®§
¥[¬°¦n¤Í
yen956
·í«eÂ÷½u
UID
12058
©«¤l
522
¥DÃD
36
ºëµØ
1
¿n¤À
603
ª÷¿ú
603
ÂI¦W
0
§@·~¨t²Î
win xp sp3
³nÅ骩¥»
Office 2003
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
319 ¤p®É
µù¥U®É¶¡
2012-12-13
³Ì«áµn¿ý
2021-7-11
°ª¤¤¥Í
©«¤l
522
¥DÃD
36
ºëµØ
1
¿n¤À
603
ÂI¦W
0
§@·~¨t²Î
win xp sp3
³nÅ骩¥»
Office 2003
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2012-12-13
³Ì«áµn¿ý
2021-7-11
2
#
µoªí©ó 2016-3-14 10:12
|
¥u¬Ý¸Ó§@ªÌ
§Aªº¬O2003?
¥i§ï¥Î
=int(A/B)
©Î°Ñ¦Ò¤U¹Ï:
¤U¸ü
(46.73 KB)
2016-3-14 10:12
TOP
rouber590324
µoµu®ø®§
¥[¬°¦n¤Í
rouber590324
·í«eÂ÷½u
UID
18546
©«¤l
561
¥DÃD
160
ºëµØ
0
¿n¤À
725
ª÷¿ú
725
ÂI¦W
0
§@·~¨t²Î
WINDOWS
³nÅ骩¥»
xp
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
®ç¶é
¦b½u®É¶¡
557 ¤p®É
µù¥U®É¶¡
2014-9-10
³Ì«áµn¿ý
2024-8-7
°ª¤¤¥Í
©«¤l
561
¥DÃD
160
ºëµØ
0
¿n¤À
725
ÂI¦W
0
§@·~¨t²Î
WINDOWS
³nÅ骩¥»
xp
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
®ç¶é
µù¥U®É¶¡
2014-9-10
³Ì«áµn¿ý
2024-8-7
3
#
µoªí©ó 2016-3-14 10:40
|
¥u¬Ý¸Ó§@ªÌ
DEAR yen956 ¤j¤j
1.·PÁ«ü¾É©ó¼W¯q¶°³B
2.¹Ï¤@¨Ï¥ÎINT =1000¥¿½T.¨Ï¥ÎQUOTIENT¨q¥X=999???¤£¬OÀ³¸Ó¨q¥X1000¶Ü?
3.·Ð¤£§[¦A½ç±Ð. THANKS*10000
¹Ï¤@
=INT(1100/1.1)=1000
=QUOTIENT(1100,1.1)=999
ù
TOP
yen956
µoµu®ø®§
¥[¬°¦n¤Í
yen956
·í«eÂ÷½u
UID
12058
©«¤l
522
¥DÃD
36
ºëµØ
1
¿n¤À
603
ª÷¿ú
603
ÂI¦W
0
§@·~¨t²Î
win xp sp3
³nÅ骩¥»
Office 2003
¾\ŪÅv
50
©Ê§O
¨k
¦b½u®É¶¡
319 ¤p®É
µù¥U®É¶¡
2012-12-13
³Ì«áµn¿ý
2021-7-11
°ª¤¤¥Í
©«¤l
522
¥DÃD
36
ºëµØ
1
¿n¤À
603
ÂI¦W
0
§@·~¨t²Î
win xp sp3
³nÅ骩¥»
Office 2003
¾\ŪÅv
50
©Ê§O
¨k
µù¥U®É¶¡
2012-12-13
³Ì«áµn¿ý
2021-7-11
4
#
µoªí©ó 2016-3-14 11:33
|
¥u¬Ý¸Ó§@ªÌ
¦^´_
3#
rouber590324
¨S¿ù, INT<>QUOTIENT, ÁÂÁ«ü¥¿!!
TOP
rouber590324
µoµu®ø®§
¥[¬°¦n¤Í
rouber590324
·í«eÂ÷½u
UID
18546
©«¤l
561
¥DÃD
160
ºëµØ
0
¿n¤À
725
ª÷¿ú
725
ÂI¦W
0
§@·~¨t²Î
WINDOWS
³nÅ骩¥»
xp
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
®ç¶é
¦b½u®É¶¡
557 ¤p®É
µù¥U®É¶¡
2014-9-10
³Ì«áµn¿ý
2024-8-7
°ª¤¤¥Í
©«¤l
561
¥DÃD
160
ºëµØ
0
¿n¤À
725
ÂI¦W
0
§@·~¨t²Î
WINDOWS
³nÅ骩¥»
xp
¾\ŪÅv
50
©Ê§O
¨k
¨Ó¦Û
®ç¶é
µù¥U®É¶¡
2014-9-10
³Ì«áµn¿ý
2024-8-7
5
#
µoªí©ó 2016-3-14 11:37
|
¥u¬Ý¸Ó§@ªÌ
DEAR yen956 ¤j¤j
1.QUOTIENT =¶Ç¦^¨â¼Æ¬Û°£©Ò±o¤§°Óªº¾ã¼Æ³¡¤À:¹Ï¤@
1.1 1100/1.1=1000 ©Ò¥H QUOTIENT(1100,1.1)=1000¤~¹ï ¦ý¨q¥X999???
½Ð±Ðì¦]¬°¦ó???
2.·Ð¤£§[¦A½ç±Ð. THANKS*10000
¹Ï¤@
QUOTIENT
¶Ç¦^¨â¼Æ¬Û°£©Ò±o¤§°Óªº¾ã¼Æ³¡¤À¡C³oÓ¨ç¼Æ¥i¥H¥Î¨Ó°£¥h¨â¼Æ¬Û°£µ²ªGªº¾l¼Æ³¡¤À¡C
QUOTIENT(numerator,denominator)
Numerator ¬°³Q°£¼Æ¡C
Denominator ¬°°£¼Æ¡C
ù
TOP
ÀR«ä¦Û¦b :
¬°¤H³B¥@n¤p¤ß²Ó¤ß¡A¦ý¤£n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí
¤U¤@¥DÃD
¤W¤@¥DÃD
EXCEL±MÄÝ°Q½×°Ï
Excel£¸¯ë°Ï
Excelµ{¦¡°Ï
¶i¶¥À³¥Î±M°Ï
OFFICE ¨t¦C
Word
PowerPoint
Access
Office¤£¤À°Ï
µ{¦¡»y¨¥
VB »P VB.Net
C »P C#
Java »P J#
µ{¦¡³]p¤£¤À°Ï
¸ê®Æ®w
ORACLE
My SQL
MS SQL
ºô¶³]p
ASP »P ASP.NET
PHP
PHP+MySQL ¤Jªù¹ê§@
JavaScript
FLASH / ActionScript
HTM/ HTML/ CSS
ºô¶³]p¤£¤À°Ï
¹q¸£»P§@·~¨t²Î
¹q¸£¦UºØµwÅé°Q½×
¤@¯ë¹q¸£³nÅé°Q½×
½×¾Â¨Æ°È
ºÞ²z¤½§i
§ë¶D¤Ï¬M
·s¤â´ú¸Õ
·R ¡E ¥Í¬¡
¤½¯q§G§iÄæ
¥Í¬¡»P·P°Ê
[¦¬Âæ¹¥DÃD]
[Ãöª`¦¹¥DÃDªº·s¦^´_]
[³q¹L QQ¡BMSN ¤À¨Éµ¹ªB¤Í]
¥Ó½Ð¤Í±¡Ãì±µ
Facebook¯»µ·