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

[µo°Ý] ¦pªG­n¼g¦h­ÓIF§P§O¦¡¤S­n²µu?¸Ó¦p¦ó°µ©O?

[µo°Ý] ¦pªG­n¼g¦h­ÓIF§P§O¦¡¤S­n²µu?¸Ó¦p¦ó°µ©O?

IF(IF(ISERROR(FIND("¬¡°Ê",$D8))+(ISNUMBER(FIND("¬¡°Ê",$D8))*(--TEXT(C8,"00!:00")>0.49)),B8,B8-1)=100,1231)

³Ì«á­±ªº100©M1231·|¦³¦n´X­Ó
¨Ò¦p200´N¬O131
300´N¬O231
400´N¬O330
µ¥¤@ª½¤U¥h¦@12ºØ

§Ú´¿¸g¹Á¸Õ¨Ï¥ÎCtrl+F3ªº¦WºÙºÞ²z­û
§âIF(ISERROR(FIND("¬¡°Ê",$D8))+(ISNUMBER(FIND("¬¡°Ê",$D8))*(--TEXT(C8,"00!:00")>0.49)),B8,B8-1)©w¸q¦¨dd
¥i¬O¦n¹³¥¢±Ñ¤F~ÁÙ¬O»¡§Ú¤£·|¨Ï¥Î~

³Â·Ð¦U¦ì¤j¤j¤F~·P®¦

¥»©«³Ì«á¥Ñ kimbal ©ó 2011-9-13 15:15 ½s¿è

¦pªG±ø¥ó¬O³sÄòªº
100,200,300,400,500,...1200
¥i¥H¥ÎCHOOSE
CHOOSE(IF(ISERROR(FIND("¬¡°Ê",$D8))+(ISNUMBER(FIND("¬¡°Ê",$D8))*(--TEXT(C8,"00!:00")>0.49)),B8,B8-1)/100,1231,131,231,330,...)


¤£µM±o°µ­ÓVLOOKUPªºªí
À´±oµo°Ý,µª®×´N·|¦b¨ä¤¤

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

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD