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

[µo°Ý] excel¦p¦ó§ä¤£¦P¤u§@ªí¤¤ªº¬Y¤ë³Ì«á¤@µ§¸ê®Æ»P¤é´Á

[µo°Ý] excel¦p¦ó§ä¤£¦P¤u§@ªí¤¤ªº¬Y¤ë³Ì«á¤@µ§¸ê®Æ»P¤é´Á

¤½.JPG
2014-5-13 15:08


­ì¦³µo©«½Ð¨D°ª¤â¨ó§U¡A¦ý¤£¾å±o¬°Ô£¤£¨£¤F
¦]¦¹­«µo¤@¦¸¨D°ª¤âÀ°¦£

§Ú·Q­pºâ¬Y°òª÷¸ê®Æªº¤ë³ø¹S
¦ý¤@¨Ç°ÝÃDµLªk§JªA
1.¦p¤é´ÁÄ椤 ¸ê®Æ¬O±qE13¶}©l¡A¤@ª½¨ì¤µ¤Ñ(ÀH®É¶¡§ó·s)
2.²b­È§ó·s¸ê®Æ¬O©ñ¦b¡y¤u§@ªí1¡z¡A¦ý§Ú¼g¤½¦¡ªº¦a¤è¬O¦b¡y¤u§@ªí¤G¡z
§Ú¸ÕµÛ¼g¤U¦C¤½¦¡
INDEX(INDIRECT("¤u§@ªí1!E14:G"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)),SUMPRODUCT((MONTH(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))<=2)*(YEAR(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))=2012)*1),3)/INDEX(INDIRECT("¤u§@ªí1!E14:G"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)),SUMPRODUCT((MONTH(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))<=1)*(YEAR(INDIRECT("¤u§@ªí1!E14:E"&MATCH(TODAY()-1,¤u§@ªí1!$E:$E,0)))=2012)*1),3)-1
¤]´N¬O  (2012¦~2¤ë³Ì«á¤@­Ó¤é´Áªº²b­È)/(2012¦~1¤ë³Ì«á¤@­Ó¤é´Áªº²b­È)-1  =2012¦~2¤ëªº¤ë³ø¹S

¦ý¬O¶]¥X¨Óªº­È¦³¿ù¡A¤£ª¾°ÝÃD¦b­þ

«á¨Ó§Ú¦A¦¸¬ã¨s¡A¥Ø«e¤w¦¨¥\¼g¥X¨Ó¤F
¤£¹LÁÙ¬OÁÂÁ¤F

TOP

        ÀR«ä¦Û¦b : ¯¸¦b¥b¸ô¡A¤ñ¨«¨ì¥Ø¼Ð§ó¨¯­W¡C
ªð¦^¦Cªí ¤W¤@¥DÃD