ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¸Ó«ç»ò­pºâ¼úª÷???

[µo°Ý] ¸Ó«ç»ò­pºâ¼úª÷???

ªª¤¦¼ÓÀ\ÆU·s¼W¼úÀy¡G¤Z·í¤ë¢°¢´¢¯¦¸©Î¢°¢¯¢¯¦¸¤Î­È©]¯Z¢±¦¸¡A¥i¨ú±oªª¤¦¤§¬Pªº¸ê®æ¤@¦¸
¸ê®æ«O«ù³sÄò¢²¦¸¥i±o¢±¢¯¢¯¢¯¤¸¼úª÷¡A¸ê®æ«O«ù³sÄò¢µ¦¸¥i±o¢±¢¯¢¯¢¯¤¸¼úª÷¡A¸ê®æ«O«ù³sÄò¢°¢±¦¸¥i±o¢´¢¯¢¯¢¯¤¸¼úª÷
½Ð°Ý3¦¸¿z¿ïªº±ø¥ó§Ú§¹¦¨¤F??¸Ó«ç»ò¥[¤J6¦¸¤Î12¦¸ªº¿z¿ï±ø¥ó??
ÁÂÁ¤j®a,¯¬¤j®a°·±d©¯ºÖ
ªª¤¦¤§¬P.jpg

¬¡­¶Ã¯1.rar (8.68 KB)

jeason

¥»©«³Ì«á¥Ñ ­ã´£³¡ªL ©ó 2019-8-3 12:23 ½s¿è

¶W¹L12¦¸, ¨Ò¦p³sÄò15¦¸, «çºâ???
3¦¸»P6¦¸¤@¼Ëª÷ÃB, ¦ó¥²¤À¶}­pºâ???
³sÄò10¦¸, ¦p¦óºâ???

TOP

¦^´_ 2# ­ã´£³¡ªL

¶W¹L12¦¸®É¡A¨C12¦¸µo10000¡A(¥i¬O§Ú¥u·Q¥ý¸Ñ¨M2¦~¤ºªº°ÝÃD´N¦n..¥H«áªº¥H«á¦A»¡.©È¤Ó³Â·Ð.....¦]¬°ÁÙ­n·Q¦³¥i¯à3¦¸(©Î6¦¸)¤¤Â_«á­«­pªº°ÝÃD....)
³sÄò10¦¸¬O¨S¦³ªº
´N¬O³sÄò²Ä3,6,12,24,36¦¸¤~¦³¼úª÷
¨ä¥Lªº¦¸¼Æ³£¨S¦³¼úª÷
¦Ü©ó±z°Ýªº3¦¸»P6¦¸¤@¼Ëª÷ÃB, ¦ó¥²¤À¶}­pºâ???
§ÚÁÙ¨S·Q³z¥¦¬O§_¦³®t²§¡A¥ý§â¤½¥q¤å¦r©ñ¤W¨Ó¦A»¡
ÁÂÁª©¥D±zªº´£°Ý
jeason

TOP

ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 3# brabus


¨Ì§Aªº³W«h,
¥H10­Ó¤ë¬°¨Ò, 1111111111 ---  ³sÄò10¦¸ --- ·í6¦¸­pºâ = 2000
¦P¼Ë10­Ó¤ë, 1111110111 --- ³sÄò6¦¸ + ³sÄò3¦¸ = 2000 + 2000
¬O§_¥Ù¬Þ???
=================================
³sÄò3¦¸»P6¦¸­Y¬O¬Û¦Pª÷ÃB, «h6¦¸¬O¤£¶·§PÂ_, ±ø¥ó¥u¶·3¦¸¤Î12¦¸§Y¥i~~

TOP

¦^´_ 3# brabus


¥ý¬Ý°Ñ¦ÒÀÉ:
Xl0000449.rar (5.5 KB)

F6:
=(N(F5)*(F5<>12)+1)*(C6+(D6>1)*50>=150)

G6:
=(F6=3)*(F9<>6)*2000+(F6=6)*(F12<>12)*2000+(F6=12)*3000

TOP

¦^´_ 4# hcm19522


    ÁÂÁÂH¤jªº¦^ÂСA¸ò±z³ø§i­n´£¿ô§A4¤ë¥÷¬O9¦¸...¨S¦³¼úª÷ªº.....
jeason

TOP

¦^´_ 5# ­ã´£³¡ªL

¦pªG¤@ª½³£»â6¦¸+3¦¸ªº2­Ó2000¤¸¡A¨º¬O·|¥Ã»·»â¤£¨ì10000¤¸ªº.....
jeason

TOP

¦^´_ 8# brabus

=(F6=3)*(F9<>6)*2000+(F6=6)*(F12<>12)*2000+(F6=12)*5000

TOP

«Ü©êºp,«e´X¤Ñ¤£¦b®a,©Ò¥H¦³ÂI±ß¦^ÂÐ
ÁÂÁ¤j®aªº¦^ÂÐ
±q¤j®aªº¤À¨ÉÅý§Ú¤S¾Ç¨ì¥i¥Hª½±µ¥Î(F6<>12)·í§@§PÂ_ªº¨Ì¾Ú¦Ó¥i¥H¤£¥ÎIF()¨ç¼Æ
¤S¦h¾Ç¤F¤@©Û
¦A¦¸ÁÂÁª©¥D­ã´£³¡ªLªº¦^ÂÐ
·P®¦¤j®a......
jeason

TOP

        ÀR«ä¦Û¦b : ¤Ó¶§¥ú¤j¡B¤÷¥À®¦¤j¡B§g¤l¶q¤j¡A¤p¤H®ð¤j¡C
ªð¦^¦Cªí ¤W¤@¥DÃD