No. | ¼ÁÌ䡦²óÅú | ¤ª¤ì¤¤ |
|
[57018] ¥¨¥¯¥»¥ë¡§¿ô¼°¤ÇÂбþ¥»¥ë¤Ë²¿¤âÆþÎϤ·¤Æ¤¤¤Ê¤¤¤Î¤Ëʸ»ú¤¬Æþ¤Ã¤Æ¤·¤Þ¤¦ |
|
|
¥¨¥¯¥»¥ë¤Ë´Ø¤¹¤ë¼ÁÌä¤ò¤ª´ê¤¤¤·¤Þ¤¹¡£
IF(AND(D3=640,E3=480),"Error",IF(D3=640,"r",IF(D3=0,"l",IF(E3=0,"u",IF(E3=480,"d",)))))
¤È¤¤¤¦¿ô¼°¤¬¤¢¤ê¤Þ¤¹¡£ÌÜÏÀ¤ß¤È¤·¤Æ¤Ï
¡¡§D3¤Ë640¤«¤ÄE3¤Ë480¤Î¾ì¹ç¤ÏError¤Èɽ¼¨
¢¡§D3¤¬640¤Î¾ì¹ç¤Ïr¤Èɽ¼¨¡Ê¡¤Î¾ò·ï¤ËÅö¤Æ¤Ï¤Þ¤é¤Ê¤¤¾ì¹ç¤Î¤ß¡Ë
£¡§D3¤¬0¤Î¾ì¹ç¤Ïl¤Èɽ¼¨
¤¡§E3¤¬0¤Î¾ì¹ç¤Ïu¤Èɽ¼¨¡Ê£¤Î¾ò·ï¤ËÅö¤Æ¤Ï¤Þ¤é¤Ê¤¤¾ì¹ç¤Î¤ß¡Ë
¥¡§E3¤¬480¤Î¾ì¹ç¤Ïd¤Èɽ¼¨¡Ê¡¤Î¾ò·ï¤ËÅö¤Æ¤Ï¤Þ¤é¤Ê¤¤¾ì¹ç¤Î¤ß¡Ë
¤È¤¤¤¦¤â¤Î¤Ç¤¹¡£
¼ÂºÝ¤³¤ì¤é¤ÎÆâÍƤϤ¦¤Þ¤¯¤¤¤Ã¤¿¤Î¤Ç¤¹¤¬¡ÖD3,E3¤Ë²¿¤âÆþÎϤ·¤Æ¤¤¤Ê¤¤¤È¤¡×¤Ë²¿¸Î¤«l¤¬É½¼¨¤µ¤ì¤Æ¤·¤Þ¤¤¤Þ¤¹¡£¤½¤³¤Ç¡ÖD3,E3¤Ë²¿¤âÆþÎϤ·¤Æ¤¤¤Ê¤¤¤È¤¡×¤Ë¤Ï¥»¥ë¤Ï¶õÍó¤Î¤Þ¤Þ¤Ë¤·¤¿¤¤¤Î¤Ç¤¹¤¬¡¢¤É¤Î¤è¤¦¤Ë¼°¤òÊѹ¹¤·¤¿¤é¤è¤¤¤Ç¤·¤ç¤¦¤«¡£
¤É¤Ê¤¿Íͤ«¤´Â¸ÃΤÎÊý¤¬¤¤¤é¤Ã¤·¤ã¤¤¤Þ¤·¤¿¤é¡¢¤è¤í¤·¤¯¤ª´ê¤¤¤·¤Þ¤¹¡£
kairi (̤ÅÐÏ¿) 2005ǯ1·î18Æü16:35
|
|
|
|
[57019] |
¤¢¤ë°ÕÌ£ÅöÁ³¤Î·ë²Ì¤Ç¤¹¤Í¡£ifʸ¤Ç¤Ï¡Ö²¿¤âÆþ¤Ã¤Æ¤Ê¤¤¡×¥»¥ë¤ò
¿ôÃÍÈæ³Ó¤¹¤ë¤È¥¼¥í¤È¤·¤Æɾ²Á¤·¤Þ¤¹¤Î¤Ç¡£
¤Ç¤¹¤Î¤Ç¡¢²¿¤âÆþ¤Ã¤Æ¤Ê¤¤¾õÂÖ¤òÀè¤Ëʸ»úÎó¤È¤·¤Æ¤Ï¤¸¤¯É¬Íפ¬¤¢¤ê¤Þ¤¹¡£
=if(and(d3="",e3=""),"",IF(AND(D3=640,E3=480),"Error",
IF(D3=640,"r",IF(D3=0,"l",IF(E3=0,"u",IF(E3=480,"d",))))))
¤Ç¡¢¤¤¤¤¤ó¤¸¤ã¤Ê¤¤¤Ç¤·¤ç¤¦¤«¡©¡Êmory¤Î½¤ÀµÉôʬ¤Ï¾®Ê¸»ú¤Ç¤¹¡Ë
mory (512) 2005ǯ1·î18Æü16:59
|
|
|
|
[57034] |
mory¤µ¤ó¡¢¤ªÊÖ»ö¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤¹¡£
¤Ê¤ë¤Û¤É¡¢¤È¤¤¤¦¤«¼«Ê¬¤ÎÉÔÊÙ¶¯¤µ¤¬Éâ¤Ä¦¤ê¤Ë¤Ê¤ê¾ð¤±¤Ê¤¤¤ä¤é²¿¤ä¤é¡£
¼Â¹Ô¤·¤Æ¤ß¤¿¤È¤³¤í¤¦¤Þ¤¯¤¤¤¤Þ¤·¤¿¡£
¤É¤¦¤â¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿^^
kairi (̤ÅÐÏ¿) 2005ǯ1·î19Æü00:25
|
|
|
|
( »²¾È¿ô:1207 ÆüÊ¿¶Ñ:0.2 ) |
|
¡Á¡¡²óÅú¤Î¼õÉÕ¤ò½ªÎ»¤·¤Þ¤·¤¿¡¡¡Á |