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

[µo°Ý] if±ø¥ó¦¡¥i§_§ïÅÜÃC¦â©O?

[µo°Ý] if±ø¥ó¦¡¥i§_§ïÅÜÃC¦â©O?

hi dear all
¥Ø«e¼g¤@­Ó±ø¥ó¦¡
ifªº¨ç¼Æ
·QÅýif=ture®É¦^¶Ç¸Ó¼Æ¦r¨Ã§ïÅÜÃC¦â,¤£ª¾¬O§_¥i¦æ
¨Ò¦p:


¦bB5¼g¤U±ø¥ó¦¡,¥i¥HÅܼƦrÅܤå¦r,¦ý¦p¦óÅܶñº¡ªºÃC¦â©Î¬O¤å¦rÃC¦â©O?
ÁÂÁÂ

¥Î®æ¦¡¤Æ±ø¥ó¬Ý¬Ý.
B5 ªº®æ¦¡¤Æ±ø¥ó,¨Ï¥Î ¤½¦¡ =(IF($K$2>=MAX(2:2),"true","false"))="true"
§Úªº office ¬O 2003ª©,´ú¸Õok

®æ¦¡¤Æ±ø¥óªº ¹Ï¼Ë ­n°O±o¿ïÃC¦â

TOP

B5 ªº®æ¦¡¤Æ±ø¥ó ¤½¦¡:
=$K$2>=MAX(2:2)
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

¤µ¤éの¤@¬íは  ©ú¤éにない
http://kimbalko-chi.blogspot.com
http://kimbalko.blogspot.com

TOP

¥»©«³Ì«á¥Ñ momowu ©ó 2010-7-27 13:24 ½s¿è

·PÁÂjackdream¤j¤j»Pkimbalª©¤j
¦b¦P¤@­Ósheet¸Ì´ú¸ÕOK
¤£¹L,¦n¹³¤£¯à¨Ï¥Î¨Ó·½¬°¨ä¥Lsheetªº¼Ò¦¡
¨Ó·½­Y¬°¨ä¥Lsheet,ÁÙ¦³¤èªk¥i¥H¸Õ¸Õ¶Ü
ÁÂÁÂ

PS¥t¥~maxªº¥Îªk¤@©w­n§tµ¥©ó¤~¥i¥H¥Î¶Ü
¨Ò¦p
"=$K$2>=MAX(2:2)"
¤£¯à"=$K$2>MAX(2:2)"³o¼Ë¶Ü

TOP

¦b¦P¤@­Ósheet¸Ì´ú¸ÕOK
¤£¹L,¦n¹³¤£¯à¨Ï¥Î¨Ó·½¬°¨ä¥Lsheetªº¼Ò¦¡
¨Ó·½­Y ...
momowu µoªí©ó 2010-7-27 11:04


±z¦n! ¥i¨Ï¥Î ©w¸q ªº¤è¦¡¸ó¶V¤u§@ªí
½Ð°Ñ¦Ò½׾ http://gb.twbts.com/index.php?topic=8654.0

TOP

¥»©«³Ì«á¥Ñ momowu ©ó 2010-7-27 18:01 ½s¿è

ÁÂÁÂjackdream¤j¤j´£¸ê®Æ
¾\Ū«á­Y¿ï¨ú¨â­Ósheet,
excelªº®æ¦¡¤Æ±ø¥ó´N·|¤Ï¥Õ
³o·|¬Oª©¥»°ÝÃD¶Ü...

ÁÙ¦³½d¨Ò¦]Åv­­°ÝÃDµLªk¤U¸ü,¥i¥Hemailµ¹§Ú¸Õ¸Õ¶Ü
[email protected]

TOP

¦^´_ 6# momowu


    ¬°¦ó¤@¦¸¿ï2­Ó¤u§@ªí?
¦]¬°¤u§@ªí¤£¦P,©Ò³y¦¨ªº¤u§@ªí°Ñ·Ó´N·|¤£¦P©Ò¥H±ø¥ó¦¡ªº¤½¦¡·|¤£¦P
­Y¿ï¨ú2­Ó¤u§@ªí­n¥Î¸s²Õ¤è¦¡¿é¤J¬O¤£¥i¦æªº
¦b³]©w®æ¦¡±ø¥ó»P©w¸q¦WºÙ¯S§O­nª`·Nµ´¹ï°Ñ·Ó»P¬Û¹ï°Ñ·Ó
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 6# momowu


   

TOP

·PÁÂHsiehª©¤j»¡©ú¬Ü¬Ü¨¤¨¤
¤]ÁÂÁÂPD961A¤j¤j´£¨Ñ½d¨Ò
²×©ó·dÀ´,¦A¦¸Á°Õ

TOP

        ÀR«ä¦Û¦b : ½_ÁJµ²±o¶V¹¡º¡¡A¶V·|©¹¤U««¡A¤@­Ó¤H¶V¦³¦¨´N¡A´N­n¶V¦³Á¾¨Rªº¯ÝÃÌ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD