¥­¥à¥é¥Ü¡ÁÀÇÍý»Î ¤­¤à¤é¤¢¤­¤é¤³¡ÊÌÚ¼Áï»Ò¡Ë¤Î¥»¥ë¥Õ¥³¥ó¥È¥í¡¼¥ë¸¦µæ½ê

¡Ö¤¢¤Ê¤¿¤Î1Æü¤Ï27»þ´Ö¤Ë¤Ê¤ë¡£¡½¡½¡Ö¼«Ê¬¤À¤±¤Î3»þ´Ö¡×¤òºî¤ë¿ÍÀ¸¡¦»Å»ö¤ÎĶÀ°ÍýË¡¡×¡Ê¥À¥¤¥ä¥â¥ó¥É¼Ò¡ËÃø¼Ô¤ÇÀÇÍý»Î¤ÎÌÚ¼Áï»Ò¡Ê¤­¤à¤é¡¦¤¢¤­¤é¤³¡Ë¤¬¤ªÁ÷¤ê¤¹¤ë¡¢¥Ð¡¼¥Á¥ã¥ë¤Ê¸¦µæ½ê¡£»þ´Ö¡¦¹ÔÆ°¡¦¤ª¶â¤Î¥»¥ë¥Õ¥³¥ó¥È¥í¡¼¥ë¤Ë´Ø¤¹¤ë¾ðÊó¤òÃæ¿´¤Ë¤ªÆϤ±¤·¤Æ¤¤¤Þ¤¹¡ª¤ª¤½¤é¤¯¡¢ÆüËܤǰìÈÖǯ´Ö°ÜÆ°µ÷Î¥¤ÎŤ¤¡¢Î¹¤¹¤ëÀÇÍý»Î¤Ç¤â¤¢¤ê¤Þ¤¹¡£

¤³¤Î¤¿¤Ó¡¢¿·¤·¤¤¥Ö¥í¥°¤òΩ¤Á¾å¤²¤Þ¤·¤¿¡£º£¸å¤Ï¤³¤Á¤é¤Ç¹¹¿·¤ò¤·¤Æ¤Þ¤¤¤ê¤Þ¤¹¡£
¡¡https://akirako.jp/
°ú¤­Â³¤­¤ªÆɤߤ¯¤À¤µ¤ë¤È¤¤¤¦Êý¤Ï¡¢¤ª¼ê¿ô¤ª¤«¤±¤¤¤¿¤·¤Þ¤¹¤¬¡¢¿·¥Ö¥í¥°¤ò¥Ö¥Ã¥¯¥Þ¡¼¥¯¡¢¤â¤·¤¯¤Ï¡¢¥ê¡¼¥À¡¼¤ËÅÐÏ¿¤·¤Æ失¤Þ¤·¤¿¤é´ò¤·¤¤¤Ç¤¹¡£¤³¤Á¤é¤Î¥Ö¥í¥°¡Ê¥é¥¤¥Ö¥É¥¢¥Ö¥í¥°¡Ë¤Ï¹¹¿·¤Ï¤·¤Þ¤»¤ó¤¬¡¢»Ä¤·¤Æ¤ª¤­¤Þ¤¹¡£
¤´Ë¬Ìä¡¢¤¢¤ê¤¬¤È¤¦¤´¤¶¤¤¤Þ¤·¤¿¡£


IT¡¦¥Ö¥í¥°¡¦SNS¡¡ ½êÆÀÀÇ > ÃùÃߤÈÀǶâ

¡Ú2016.2.25Äɵ­¡Û
Ê¿À®28ǯ¤«¤é¤ÎͶâÍø©¤ÎÀǶâ·×»»ÊýË¡¤òÃΤꤿ¤¤Êý¤Ï¡¢¤³¤Á¤é¤Î¥¨¥ó¥È¥ê¡¼¤ò¤´Í÷¤¯¤À¤µ¤¤¡ª

¡ÚÊ¿À®28ǯ¡Á¡ÛͶâÍø©¼ê¼è¤ê³Û¤«¤é¡¢½êÆÀÀÇÉü¶½½êÆÀÀǤò·×»»¤¹¤ëÊýË¡¡ª : kimutax ¥«¥Õ¥§¡Ê¤­¤à¥«¥Õ¥§¡Ë

ͶâÍø©¼ê¼è³Û¤«¤éµÕ»»¤·¡¢Éü¶½ÆÃÊ̽êÆÀÀǡʰʲ¼¡ØÉü¶½Àǡ١˹þ¤ß¤Î¸»Àôħ¼ýÀdzۤò·×»»¤¹¤ëExcel¥Õ¥¡¥¤¥ë¤òºî¤Ã¤Æ¤ß¤Þ¤·¤¿¡£

¤Ç¡¢¤»¤Ã¤«¤¯¤À¤«¤é¤½¤Î¡Ö¥ì¥·¥Ô¡Êºî¤êÊý¡Ë¡×¤ò¸ø³«¤·¤è¤¦¤È¤¤¤¦Á´3²ó¤Îµ­»ö¡£º£Æü¤Ï¤½¤ÎÂè2²ó¤Ç¤¹¡£

¡ÊÁ°ÊԡˤϤ³¤Á¤é¤«¤é¡£


¡Ê¤¹¤Ù¤Æ¤ÎExcel¤Î²èÁü¤Ï¥¯¥ê¥Ã¥¯¤¹¤ë¤È³ÈÂ礷¤Æ¸«¤ë¤³¤È¤¬¤Ç¤­¤Þ¤¹¡Ë

­» ½êÆÀÀǤÈÉü¶½ÀǤËʬ¤±¤ë

ºÇ¸å¤Ë¤·¤ÆºÇÂç¤Î¥ä¥Þ¡£½êÆÀÀǤÈÉü¶½ÀǤòʬ¤±¤Þ¤¹¡£

Éü¶½ÀǤη׻»¼°¤Ï¡Ö¹ñÀÇʬ¡ß2.1/102.1¡Ê50Á¬Ä¶¤òÀÚ¤ê¾å¤²¡Ë¡×¡£
¤³¤ì¤Ï¯¤Ë¡Ö¸Þ¼Î¸ÞĶÆþ¡×¤È¤¤¤ï¤ì¤ë¼Ò²ñÊݸ±´ØÏ¢¤Ê¤É¤Ç¤Ï¤è¤¯¸«¤é¤ì¤ëü¿ô½èÍý¤Ç¤¹¡£»Í¼Î¸ÞÆþ¤ÏROUND´Ø¿ô¤ò»È¤¨¤Ð´Êñ¤Ë¤Ç¤­¤ë¤Î¤Ç¤¹¤¬¡¢¤³¤ì¤Ë¤Ï¥¢¥¿¥Þ¤òǺ¤Þ¤»¤Þ¤·¤¿¡Ä¡£

Ǻ¤ó¤À·ë²Ì¡¢»ä¤Ï¤³¤¦¤¤¤¦¼°¤òÆþ¤ì¤Æ¤ß¤Þ¤·¤¿¡£
¤â¤Ã¤È¤¤¤¤ÊýË¡¤¢¤ë¤è¡¢¤È¤¤¤¦Êý¤¤¤é¤Ã¤·¤ã¤¤¤Þ¤·¤¿¤é¡¢¶µ¤¨¤Æ¤¯¤À¤µ¤¤¡ª

KIM blog-8 130112


=IF(E2*2.1/102.1¡ÝINT(E2*2.1/102.1)¡ä0.5,INT(E2*2.1/102.1)+1,INT(E2*2.1/102.1))
=IF(Éü¶½ÀÇü¿ô½èÍýÁ°¡ÝÉü¶½ÀÇü¿ôÀڼΡä0.5,Éü¶½ÀÇü¿ôÀÚ¼Î+1,Éü¶½ÀÇü¿ôÀÚ¼Î)

¤³¤Î¼°¤Î°ÕÌ£¤Ï
Éü¶½ÀǤÎü¿ô¤¬0.5¤è¤êÂ礭¤±¤ì¤Ð¡¢Éü¶½ÀÇü¿ôÀڼγۡÜ1¤È¤·¡¢¤½¤¦¤Ç¤Ê¤¤¾ì¹ç¤ÏÉü¶½ÀÇü¿ôÀڼγۤȤ¹¤ë
¤Ç¤¹¡£¤³¤ì¤Ç¸Þ¼Î¸ÞĶÆþ¤Ë¤Ê¤ë¡ª

¤³¤³¤Ç»È¤Ã¤Æ¤¤¤ëINT´Ø¿ô¤Ë¤Ä¤¤¤Æ¤´ÀâÌÀ¤·¤Þ¤¹¡ÊIF´Ø¿ô¤ÏÁ°²ó¤Ç¤´ÀâÌÀºÑ¤ß¡Ë¡£
INT´Ø¿ô
¡áINT(¿ôÃͤä¿ô¼°)
ÀÚ¤ê¼Î¤Æ¤ò¹Ô¤¤¡¢¿ôÃͤòºÇ¤â¶á¤¤À°¿ô¤Ë´Ý¤á¤ë´Ø¿ô¤Ç¤¹¡£
¤³¤ì¤Þ¤¿¤ª¤Ü¤¨¤Æ¤ª¤­¤¿¤¤´Ø¿ô¤Î°ì¤Ä¡£·å¿ô¤Î»ØÄê¤ò¤·¤Ê¤¯¤Æ¤¤¤¤Ê¬ROUNDDOWN´Ø¿ô¤è¤ê»È¤¤¤ä¤¹¤¤¤Î¤Ç¡¢Á°²ó¤Î¼°¤òINT´Ø¿ô¤ÇÁȤà¤Î¤â¥¢¥ê¤Ç¤¹¡£


­¼ ºÇ¸å¤Ë¡Ö½êÆÀÀÇ¡ÜÉü¶½Àǡפ«¤é¡ÖÉü¶½Àǡפò°ú¤¤¤¿³Û¤ò¡Ö½êÆÀÀǡפȤ¹¤ë·×»»¼°¤òÆþ¤ì¤Þ¤¹¡£

KIM blog-10 130112

¤³¤ì¤Ç´°À®¤Ç¤¹¡£¥Ñ¥Á¥Ñ¥Á¡£
¼ê¼è¤ê³ÛÆþÎϤ¹¤ë¤À¤±¤Ç¼«Æ°·×»»¡£¤³¤ì¤Ç·î¼¡¤ä·è»»¤Î»þ´Ö¤¬¾¯¡Á¤·¤À¤±Ã»¤¯¤Ê¤ë¡ª
¤¢¤È¤Ï¤ª¤³¤Î¤ß¤Ç¡¢·ÓÀþ¤ÇÁõ¾þ¤·¤¿¤ê¡£·×»»¼°¤Î¹Ô¤òÁý¤·¤Æ¤â¤è¤¤¤Ç¤·¤ç¤¦¡£

ÀÄ»ú¤Î¤È¤³¤í¤¬·×»»¼°¤¬Æþ¤Ã¤Æ¤¤¤ë¸Ä½ê¤Ç¤¹¡£»ä¤Ï¼«Ê¬¤ÇExcel¥Õ¥¡¥¤¥ë¤òºî¤Ã¤¿¤é¡¢·×»»¼°¤¬Æþ¤Ã¤Æ¤¤¤ë¤È¤³¤í¤Ë¤¦¤Ã¤«¤êÆþÎϤò¤·¤Æ¤·¤Þ¤ï¤Ê¤¤¤è¤¦¡¢¤³¤Î¤è¤¦¤Ë¿§¤òÊѤ¨¤ë¤«¡¢¼°¤¬Æþ¤Ã¤Æ¤ë¥»¥ë¤òÊݸ¤ë¤è¤¦¤Ë¤·¤Æ¤¤¤Þ¤¹¡£

¤³¤Î¤è¤¦¤Ë¸¡»»¼°¤òÆþ¤ì¤ë¤È¤Ê¤ª¤è¤¤¤Ç¤·¤ç¤¦¡£¡Ê­¡¡á­¦¡Ý­£¡Ý­¤¡Ý­¥¤Ç¤¢¤ë¤³¤È¤Î¾ÚÌÀ¡Ë

KIM blog-11 130112


­½ ¤ª¤Þ¤±

±þÍѤ¹¤ì¤Ð¡¢¾å¾ì³ôÇÛÅöÅù¤äÈó¾å¾ì³ôÇÛÅöÅù¤Î¼«Æ°·×»»¤â¤Ç¤­¤Þ¤¹¡ª

KIM blog-13 130112

¤¼¤Ò¡¢¥Á¥ã¥ì¥ó¥¸¤·¤Æ¤ß¤Æ¤¯¤À¤µ¤¤¡ª·×»»¼°¤ÎÅú¤¨¹ç¤ï¤»¤Ï¡¢¼¡²ó¡Ê¸åÊԡˤǥ¢¥Ã¥×¤·¤Þ¤¹(^o^)



¿Íµ¤¥Ö¥í¥°¥é¥ó¥­¥ó¥°¤Ø

¦Õ¡Ê¡¥¡¥¡Ëº£Æü¤ÎÀÇÍý»Î»ö̳½ê¤Î¤Ö¤Ä¤Ö¤Ä

¤¦¡¼¤ó¤¦¡¼¤ó¡¦¡¦¡¦

¤É¤¦¤·¤¿¤ó¤À¤­¤Æ¤£¤¯¤ó¡©

¤­¤à¥«¥Õ¥§¤«¤é½ÉÂ꤬½Ð¤Þ¤·¤Æ¡Ä¡£¾å¾ì³ô¤ÎÇÛÅö¤È¤«¡¢Èó¾å¾ì³ô¤ÎÇÛÅö¤ÎÀǶâ³Û¤ò¼«Æ°·×»»¤¹¤ëExcel¤òºî¤Ã¤Æ¤ë¤ó¤Ç¤¹¤¬¡¦¡¦¡¦

Ï¢µÙÊÖ¾å¤Ç¤´¶ìÏ«¤Ê¤³¤È¤À¡£¤Ç¡¢²¿¤ò¤½¤ó¤Ê¤ËǺ¤ó¤Ç¤ë¤ó¤À¡©¡ª

¤½¤â¤½¤â¡¢¤½¤ì¤¾¤ìÀǶ⤬²¿¥Ñ¡¼¥»¥ó¥È²Ý¤»¤é¤ì¤Æ¤¤¤ë¤Î¤«¤¬¡¢¤ï¤«¤é¤Ê¤¤¤ó¤Ç¤¹¡ÊÎÞ¡Ë¡£

¥¢¥Á¥ã¡¼¡Ê¼¡²ó¤Ë³¤¯¡Ë¡£

¡Ê*¡­Žª`*¡Ëº£Æü¤Î¥«¥Õ¥§

Ë¿Æü¡¢Ä«¡¢ÂǤÁ¹ç¤ï¤»¤Çµ×¡¹¤Ë¥Þ¥á¥Ò¥³¡÷»°¸®Ãã²°¤Ø¡£

38

Ä«¤Î¸÷¤¬µ¤»ý¤Á¤¤¤¤¡£
Ä«Á᤯¤«¤é¤ä¤Ã¤Æ¤¤¤ë¥«¥Õ¥§¤ÏÁᵯ¤­À¸³è¼Ô¤Ë¤È¤Ã¤Æ¤Ï¤Û¤ó¤È¤¦¤Ëµ®½Å¤Ç¤¹¡ª

00

ÁêÊѤï¤é¤º³è¤±¤Æ¤¢¤ë¤ª²Ö¡Ê»Þ¤â¤Î¡Ë¤â¤­¤ì¤¤¡£
»ä¤Ï»Å»ö¾ì¤Î¥Ç¥¹¥¯¤Þ¤ï¤ê¤Ë»Þ¤â¤Î¤ò¾þ¤Ã¤Æ¤¤¤Þ¤¹¤¬
¼Â¤Ï¥Þ¥á¥Ò¥³¤Î¿¿»÷¤Ã¤³¤Ê¤Î¤Ç¤·¤¿

37


01

Ä«¿©¤ò·ó¤Í¤Æ¥Õ¥é¥ó¥¹¥Ñ¥óµ­»ö¤Î¿©¥Ñ¥ó¡Ü¥Ï¥Ë¡¼¤Î¥È¡¼¥¹¥È
觤Ƕ̻Ҥȡ¢¿·¾¦ÉÊ¡¦¹õƦ¥³¡¼¥Ò¡¼¤Î¥«¥Õ¥§¥ª¥ì¤ò¤¤¤¿¤À¤­¤Þ¤·¤¿¡ª
¥Ñ¥ï¡¼¥Ö¥ì¥Ã¥¯¥Õ¥¡¡¼¥¹¥È¡¢¤½¤·¤Æ¥Ñ¥ï¡¼¥ß¡¼¥Æ¥£¥ó¥°¡ª
¤Á¤«¤Â¤«ÌÌÇò¤¤È¯É½¤¬¡¢¥³¥³¤Ç¤Ç¤­¤½¤¦¤Ç¤¹(¡°¡°)

¤³¤Îµ­»ö¤ò½ñ¤¤¤¿¿Í¡§ÌÚ¼Áï»Ò¡Ê¤­¤à¤é¡¦¤¢¤­¤é¤³¡Ë

ÌÚ¼Áï»Ò
ǯ´Ö°ÜÆ°µ÷Î¥ÆüËÜ°ì¡Ê¿äÄê¡Ë¤Îι¤¹¤ëÀÇÍý»Î¡£¥Ó¥¸¥Í¥¹½ñºî²È¡£¥Ð¥Ö¥ëÊø²õ¤ò¤­¤Ã¤«¤±¤Ë¡¢1993ǯ¡Ê27ºÐ¡Ë»ñ³Ê¼èÆÀ¤ò·è°Õ¡£¥Õ¥ë¥¿¥¤¥à¤ÇƯ¤­¤Ê¤¬¤é¡¢¼Â̳·Ð¸³¥¼¥íÊíµ­Ãμ±¥¼¥í¤«¤é¥¹¥¿¡¼¥È¤·Ã»´ü´Ö¤ÇÀÇÍý»Î»î¸³¹ç³Ê¡£1998ǯ¡Ê31ºÐ¡ËÀÇÍý»ÎÅÐÏ¿¡£2000ǯ¡Ê34ºÐ¡ËÌÚ¼ÀÇ̳²ñ·×»ö̳½êÁÏÀß¡£¥Ö¥í¥¬¡¼ÀÇÍý»Î¤ÎÁðʬ¤±ÅªÂ¸ºß¡£»ñ³Ê¼èÆÀ»þ¤Ë¿È¤Ë¤Ä¤±¤¿»Å»ö½Ñ¡¦»þ´Ö½Ñ¤ò¶î»È¤·¡¢¥»¥ß¥Ê¡¼¹Ö»Õ¤ä¹­Å祫¡¼¥×¤Î±þ±ç¤ÇÆüËÜÁ´¹ñ¤ò¶î¤±²ó¤ë¡£¼Â̳»ï¤Û¤«¼¹É®¼ÂÀÓ¿¿ô¡£Ãø½ñ¤Ë¡ÖÃíʸ¤Î¿¤¤ÎÁÍýŹ¤Î¾ÃÈñÀÇÂбþ¡×¡ÊÃæ±û·ÐºÑ¼Ò¡Ë¡¢¡Ö¤¢¤Ê¤¿¤Î1Æü¤Ï27»þ´Ö¤Ë¤Ê¤ë¡£¡×¡Ê¥À¥¤¥ä¥â¥ó¥É¼Ò¡Ë¡£


¥³¥á¥ó¥È

¥³¥á¥ó¥È¥Õ¥©¡¼¥à
ɾ²Á¤¹¤ë
  • 1
  • 2
  • 3
  • 4
  • 5
  • ¥ê¥»¥Ã¥È
  • 1
  • 2
  • 3
  • 4
  • 5
  • ¥ê¥»¥Ã¥È
´é
˱