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

¦p¦ó³]©w¨ú³Ì°ª¥ó¼Æ(¤w¸Ñ¨M)

¦p¦ó³]©w¨ú³Ì°ª¥ó¼Æ(¤w¸Ñ¨M)

¥»©«³Ì«á¥Ñ koala2099 ©ó 2012-2-18 16:05 ½s¿è

¦³¦n¤ßªº¤j¤j¦AÀ°§Ú¤@¤U¶Ü?
2­Ó²Õ§O
¤À§O³]¸m¤£¦P¤W­­ªùÂe
A²Õ¥ó¼Æ³Ì°ª¬°40¥¼¹FªÌ¨ú¹ê»Ú¥ó¼Æ
B²Õ¥ó¼Æ³Ì°ª¬°60¥¼¹FªÌ¨ú¹ê»Ú¥ó¼Æ

¥ó¼Æ.zip (8.89 KB)

¦^´_ 1# koala2099

C3=IF(B3>HLOOKUP(A3,$F$2:$G$3,2,0),HLOOKUP(A3,$F$2:$G$3,2,0),B3)

TOP

¦^´_ 1# koala2099
C3=MIN(B3,LOOKUP(A3,{"A²Õ","B²Õ"},{40,60}))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

=MIN((A3=$H$2)*20+40,B3)
1

µû¤À¤H¼Æ

    • gong: ¯u²¼ä¦³¤O ¥t$h$2§ó¥¿¬°$g$2ª÷¿ú + 2

TOP

¦^´_ 3# Hsieh


³ßÅw³o¥y¸Ü¡÷¾Ç®üµL²P_¤£®¢¤U°Ý
¦ý~°Ý¤]­n°Ý¹ï¤H
¹J¤W¯d¤@¤âªº¦P¨Æ·Q±o¨ìµª®×
®£©È³s·Q....¤£®¢¤]¬£¤£¤W¥Î³õ§a!
¤Ï¦Ó¬O³o¸Ìªº¦U¦ì¤j¤jÅý¤H·P¨ü¨ì·Å·x

TOP

        ÀR«ä¦Û¦b : ¡i»X½ªªº¦Û¥Ñ¡j¤H±`¦b¤°»ò³£¥i¥H¦Û¥Ñ¦Û¦bªº®É­Ô¡A«o³Q³oºØÀH¤ß©Ò±ýªº¦Û¥Ñ»X½ª¡AµêÂY®É¥ú¦Ó²@µLıª¾¡C
ªð¦^¦Cªí ¤W¤@¥DÃD