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

[µo°Ý] ¦V½u°ÝÃD

[µo°Ý] ¦V½u°ÝÃD

½Ð°Ý¸Ó¦p¦ó¼g ¦pªþ¥ó


20221114.rar (12.91 KB)

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2022-11-14 21:48 ½s¿è

©êºp  µ²ªGªº ²Ä2ÂI -5        50 À³¸Ó¬O  0        50 §Ú¥´¿ù¤F ¦³¥¿­t¼Æ°ÝÃD

TOP

¦^´_ 2# °a¤ªºµ

ÁÂÁ«e½úµoªí¦¹¥DÃD»P½d¨Ò
1.«á¾Ç¦n©_ ¦V½u¬O¤°»ò?
2.¦pªG½d¨Ò¸Ìªº¨â²Õ¼Æ¾Ú¬O¤G¦¸¦±½uªºÂI!¬O¨â±ø¦±½u


3.¥[´îªºÅܤƼƭȬO­nªí¹F¤°»ò?


4.¥i¥H»¡©ú³oµ²ªGÂI ¼Æ¾Ú¬O¤°»ò¥Î³~?
¼Æ¾ÚÂI¥u¦³3­ÓÂI,¥i¥H§k¦Xªº¤½¦¡¦n¹³«Ü¦h!

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2022-11-17 10:10 ½s¿è

¦^´_ 3# Andy2483

©êºp  µ²ªGªº ²Ä2ÂI -5        50 À³¸Ó¬O  0        50 §Ú¥´¿ù¤F

À³¸Ó¬O»¡ 3­ÓÂI  ¨ä¹ê¬O3±ø½u   ¨C¤@­ÓÂIµ¥©ó¤@±ø½u   °²³]  -10   50  ¬O°ò·ÇÂI    §Ú§Æ±æ ²Ä2²Õ  »P ²Ä3²Õ  ªº  X ¸¨¦b 50ªþªñ ¶V±µªñ¶V¦n      
¦Ó°_©lÂI  ²Ä2²Õ ¬O5  ²Ä3²Õ ¬O-25  
¥H²Ä2²Õ ¨Ó»¡  5  25   ·í 5 ¶V¤pªº®É­Ô  25 ªº¼Æ­È ´N·|¶V¤j
5~25 ªº¶¡¶Z  ¬Oµ¥¶¡¶Z ©T©w ©¹+ x ©ÎµÛ¬O -x  ¤è¦V²¾°Ê  ©Ò¥H §Ú©¹ 50ªº¤è¦V²¾°Êªº®É­Ô 5 ¸ò 25 ³£·|ÅܤÆ

TOP

¦^´_ 4# °a¤ªºµ

©êºp ­è­è¬Ý¤@¤Uµo²{ ½d¦C¦³°ÝÃD  ±q·s¦A¤W¶Ç¤@¦¸  


20221117.rar (13.28 KB)

TOP

½Ð«e½ú¸Õ¸Õ¬Ý
1.G13=IF(G6<>"",G6+((H6-$H$6)/5),"")
2.H13=IF(G6<>"",$H$6,"")
3.G13:H13 ¤U¨ê¨ì G17:H17

TOP

¦^´_ 6# Andy2483

¥i¥H¤F  ÁÂÁÂ Andy2483 ¤j¤j

TOP

Hello, °a¤ªºµ ¤j

¨Ì±zªº°ÝÃD, À³¸Ó¬O5~-25©Ò¶q´úªº­È, ¬Ò¯à¸É¥¿¦Ü±µªñ50, ¹ï¶Ü?
¦pªG¬Oªº¸Ü, ¨º»ò¤½¦¡À³¸Ó¬O::
J21=IF(H21<>"",0+((I21-$K$6)/5),"")
K21=IF(H21<>"",I21-5*J21,"")

¥H¤W, ÁÙ¬O§Ú¦³©Ò»~¸Ñ, ¦A¤£§[§iª¾. Thanks ~

[H21,I21]=[5,25] ==>[-5ÀÉ, ¸É¥¿¦Ü50]
[H22,I22]=[0,50] ==>[-0ÀÉ, ¸É¥¿¦Ü50]
[H23,I23]=[-5,50] ==>[-0ÀÉ, ¸É¥¿¦Ü50]
[H24,I24]=[-10,75] ==>[+5ÀÉ, ¸É¥¿¦Ü50]
[H25,I25]=[-15,100] ==>[+10ÀÉ, ¸É¥¿¦Ü50]
[H26,I26]=[-20,125] ==>[+15ÀÉ, ¸É¥¿¦Ü50]
[H27,I27]=[-25,150] ==>[+20ÀÉ, ¸É¥¿¦Ü50]
·s¤â¤W¸ô¡A½Ð¦h¥]²[¡C

TOP

¦^´_ 8# ¼B¤j­G
·PÁ ¼B¤j­G¤j¤j §Ú¨Sª`·N¨ì

TOP

¥»©«³Ì«á¥Ñ °a¤ªºµ ©ó 2022-11-22 18:58 ½s¿è

¦^´_ 9# °a¤ªºµ

¨ä¹ê §Ú­nªºµ²ªG¬OÃþ¦ü³o¼Ë  ©êºp §Ú»¡©úªº¤£²M·¡
¤£ª¾¹D¦³¨S¦³§ó¦nªº¿ìªk
1122.rar (32.29 KB)

TOP

        ÀR«ä¦Û¦b : §g¤l¦p¤ô¡AÀH¤è´N¶ê¡AµL³B¤£¦Û¦b¡C
ªð¦^¦Cªí ¤W¤@¥DÃD