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

½Ð°Ý¤@¤Uexcel ¶ê§Î¹Ïªíªº°ÝÃD

½Ð°Ý¤@¤Uexcel ¶ê§Î¹Ïªíªº°ÝÃD

½Ð°Ý¤@¤U¡A§Ú²{¦b­n¬Ý§Úªºªá¶O¤ñ¨Ò¡A¥Îexcel´¡¤J¤@­Ó¶ê§Î¹Ïªí¡A­ì¥»ªº¸ê®Æ¬O³o¼Ë

½Ð°Ý¦U¦ì¤j¤j¡A§Ú¦³¨â­Ó°ÝÃD·Q¸Ñ¨M
(1)¤ñ¦p§Ú·Q±N¨âµ§­«½Æªº¥Í¬¡¶O¡A9000+18500=27500¡A¦b¶ê§Î¹ÏªíÅܦ¨¤@µ§´N¦n¡A¦Ó¤£¬OÅܦ¨«Ü¦hµ§¥Í¬¡¶O¥hÅã¥Ü
(2)§Ú·Q§â¶À¦âªº¸ê®Æ¡A¤£­n¦A¶ê§Î¹Ïªí¤W¡A¦]¬°¶À¦âªºªí®æ¡A¬O§Úªº¨C¤@µ§¸ê®Æ³Ì«áªº¥[Á`¡A©Ò¥H¥i¥H¤£¥ÎÅã¥Ü¦b¶ê§Î¹Ï¡C
¥Ø«e¥¿±`¥Î¶ê§Î¹ÏÅã¥Ü®É¤j·§¬O³o¼Ë¡A¥Í¬¡¶O·|¤À¦¨«Ü¦hµ§¸ê®Æ¡A¶À¦âªí®æ(Á`©M¥Îªº)¤]·|§â¿Ä¤J¡C¥ÎVBA¿ìªk¼g¶Ü¡A¦³¤j¤j¥i¥HÀ°À°¦£©Î´£¥Ü¶Ü¡AÁÂÁ¡C

capture-20150103-172021.png (10.54 KB)

capture-20150103-172021.png

capture-20150103-173134.png (11.79 KB)

capture-20150103-173134.png

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD