[B! ã‚¨ã‚¯ã‚»ãƒ«] snaoki709ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

snaoki709 id:snaoki709

ã‚¨ã‚¯ã‚»ãƒ«ã«é–¢ã™ã‚‹snaoki709ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (5)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

FLOORé–¢æ•° ï¼ æ™‚é–“ã®åˆ‡ã‚Šæ¨ã¦ã¨ã€æ¡è½ã¡æ³¨æ„ ï¼»Excelé–¢æ•°ãƒªãƒ•ã‚¡ãƒ¬ãƒ³ã‚¹ï¼½ ï¼»æ¯”è¼ƒã¦ãã€ã€ã€ï¼½
ï¼»æ›¸å¼ï¼½ã€€FLOOR(ï¼œæ•°å€¤ï¼ž,ï¼œåŸºæº–å€¤ï¼ž) ï¼»æ©Ÿèƒ½ï¼½ã€€ï¼œæ•°å€¤ï¼ž ã‚’ ï¼œåŸºæº–å€¤ï¼ž ã®å€æ•°ã«åˆ‡ã‚Šæ¨ã¦ã¾ã™ã€‚ ï¼»å¼•æ•°ï¼½ â—â—â—ã€€æ™‚é–“ã‚’10åˆ†ã”ã¨ã«åˆ‡ã‚Šæ¨ã¦ã‚‹æ–¹æ³•ã€€â—â—â— ä»Šå›žã¯ã€æ™‚é–“ã®åˆ‡ã‚Šæ¨ã¦ã«ã¤ã„ã¦è€ƒãˆã¦ã„ãã¾ã—ã‚‡ã†ã€‚ æ™®é€šã®æ•°å€¤ã®åˆ‡ã‚Šæ¨ã¦ãªã‚‰ ROUNDDOWNé–¢æ•°ã§ã™ãŒã€æ™‚é–“ã®å ´åˆã«ã¯ã€ãã†ã¯ã„ãã¾ã› ã‚“ã€‚ã€€ãŸã¨ãˆã°ï¼‘æ™‚é–“å˜ä½ã§åˆ‡ã‚Šæ¨ã¦ãŸã„ãªã‚‰ã€ï¼‘æ™‚é–“ã®ã‚·ãƒªã‚¢ãƒ«å€¤ã§ã‚ã‚‹ 1/24 ã€ã™ãªã‚ã¡ 0.041666667 ã®å€æ•°ã«åˆ‡ã‚Šæ¨ã¦ã‚‹å¿…è¦ãŒã‚ã‚Šã¾ã™ã€‚ ã•ã¦ã€Excelã«ã¯ã€FLOORé–¢æ•°ã¨ã„ã†ã€æ•°å€¤ã‚’ä»»æ„ã®æ•°å€¤ã®å€æ•°ã«åˆ‡ã‚Šæ¨ã¦ã‚‹é–¢æ•°ãŒã‚ã‚Š ã¾ã™ã€‚ã€€ãŸã¨ãˆã°å€¤ã‚’ 0.25 ã”ã¨ã«åˆ‡ã‚Šæ¨ã¦ãŸã‘ã‚Œã°ã€ =FLOOR(ï¼œæ•°å€¤ï¼ž,0.25) ã®ã‚ˆã†ã«åˆ©ç”¨ã—ã¾ã™ã€‚ ã“ã†ã™ã‚Œã°ã€ï¼œæ•°å€¤ï¼ž ãŒ ã€Œ1.3ã€ã€€ã ã£ãŸã‚‰ã€è¨ˆç®—çµæžœã¯ã€€ã€Œ1.25ã€ ã€Œ0.7ã€ã€€ã ã£ãŸã‚‰ã€è¨ˆç®—çµæžœã¯ã€€ã€Œ0.5ã€ ã¨ã„ã†ã‚ˆã†ã«ã€0
snaoki709 2010/10/14
ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
èª°ã§ã‚‚ã§ãã‚‹ã‚¨ã‚¯ã‚»ãƒ«ãƒ‡ãƒ¼ã‚¿åˆ†æžã€€â€œã„ã¤ã‚‚ã¨é•ã†çµè«–ã‚’å°Žãã ã™â€ãŸã‚ã®ã€Œã‚¯ãƒã‚¹é›†è¨ˆã€ï¼‹ã€Œå·®åˆ†ã€ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
ã€ŽMarkeZineã€ãŒä¸»å‚¬ã™ã‚‹ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°ãƒ»ã‚¤ãƒ™ãƒ³ãƒˆã€ŽMarkeZine Dayã€ã€ŽMarkeZine Academyã€ã€ŽMarkeZine ãƒ—ãƒ¬ãƒŸã‚¢ãƒ ã‚»ãƒŸãƒŠãƒ¼ã€ã® æœ€æ–°æƒ…å ±ã‚’ã¯ã˜ã‚ã€æ§˜ã€…ãªã‚¤ãƒ™ãƒ³ãƒˆæƒ…å ±ã‚’ã¾ã¨ã‚ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ MarkeZine Day
snaoki709 2010/06/29
ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
èª°ã§ã‚‚ã§ãã‚‹ã‚¨ã‚¯ã‚»ãƒ«ãƒ‡ãƒ¼ã‚¿åˆ†æžã€€â€œæ¬¡ã«ã¤ãªãŒã‚‹æ´žå¯Ÿã‚’å¾—ã‚‹â€ãŸã‚ã®ã€Œå¼•ãç®—ã€ï¼‹ã€Œã‚½ãƒ¼ãƒˆã€ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯
ã€ŽMarkeZineã€ãŒä¸»å‚¬ã™ã‚‹ãƒžãƒ¼ã‚±ãƒ†ã‚£ãƒ³ã‚°ãƒ»ã‚¤ãƒ™ãƒ³ãƒˆã€ŽMarkeZine Dayã€ã€ŽMarkeZine Academyã€ã€ŽMarkeZine ãƒ—ãƒ¬ãƒŸã‚¢ãƒ ã‚»ãƒŸãƒŠãƒ¼ã€ã® æœ€æ–°æƒ…å ±ã‚’ã¯ã˜ã‚ã€æ§˜ã€…ãªã‚¤ãƒ™ãƒ³ãƒˆæƒ…å ±ã‚’ã¾ã¨ã‚ã¦ã”ç´¹ä»‹ã—ã¾ã™ã€‚ MarkeZine Day
snaoki709 2010/06/29
ã‚¨ã‚¯ã‚»ãƒ«
ãƒªãƒ³ã‚¯
ã‚°ãƒ©ãƒ•ä½œæˆã‚„ãƒ‡ãƒ¼ã‚¿å¯è¦–åŒ–ã‚’æ¥½ã«ç¾Žã—ãã§ãã‚‹ä¾¿åˆ©ãªã‚µãƒ¼ãƒ“ã‚¹22å€‹ã¾ã¨ã‚ | Webæ‹…å½“è€…Forum
ã“ã®ã‚³ãƒ¼ãƒŠãƒ¼ã§ã¯ã€ãƒãƒƒãƒˆãƒ“ã‚¸ãƒã‚¹ã‚’å¼·åŠ›ã«æ”¯æ´ã™ã‚‹è£½å“ã«ã¤ã„ã¦ã€ãã‚Œã‚’æ”¯ãˆã‚‹æŠ€è¡“ã‚„å¸‚å ´å‹•å‘ã‚’èª¬æ˜Žã—ã€ã•ã‚‰ã«å„ç¤¾ã‹ã‚‰æä¾›ã•ã‚Œã¦ã„ã‚‹è£½å“ã‚’ç´¹ä»‹ã™ã‚‹ã€‚ç«¶åˆå•†å“ãŒã²ã—ã‚ãå¸‚å ´ã§ã€ä»–ç¤¾ã«å·®ã‚’ä»˜ã‘ã‚‹ãŸã‚ã®æ¦å™¨ã¨ã—ã¦ã€ãœã²å°Žå…¥ã‚’æ¤œè¨Žã—ã¦ã¿ã¦ã»ã—ã„ã€‚ä»Šå›žã¯ã€ã€Œã‚°ãƒ©ãƒ•ä½œæˆãƒ»ãƒ‡ãƒ¼ã‚¿å¯è¦–åŒ–ã€ã‚µãƒ¼ãƒ“ã‚¹ã ã€‚ å£²ã‚Šä¸Šã’ã®æŽ¨ç§»ã€æ¥ç•Œã«ãŠã‘ã‚‹ã‚·ã‚§ã‚¢ã€è‡ªç¤¾è£½å“ã®å‡ºè·æ•°å†…è¨³ãªã©ãªã©â€¦ã€‚ã€Œé¡§å®¢ã®èª¬å¾—ã®ãŸã‚ã€ã‚¦ã‚§ãƒ–ã‚µã‚¤ãƒˆã§ã‚‚ã‚°ãƒ©ãƒ•è¦ç´ ã‚’æŽ²è¼‰ã—ãŸã„ã€ã¨ã„ã£ãŸã‚±ãƒ¼ã‚¹ã¯å¢—ãˆã¦ã„ã‚‹ã€‚å¤§æ‰‹ä¼æ¥ã§ã¯ã€PHPã‚’ä½¿ã„ãƒ‡ãƒ¼ã‚¿ãƒ™ãƒ¼ã‚¹ã¨é€£å‹•ã•ã›ã¦å‹•çš„ã«æœ€æ–°ã‚°ãƒ©ãƒ•ã‚’è¡¨ç¤ºã•ã›ã‚‹ã€ã¨ã„ã£ãŸä»•çµ„ã¿ã‚’ç”¨æ„ã§ãã‚‹å ´åˆã‚‚ã‚ã‚‹ãŒã€ãŸã„ã¦ã„ã¯ã€Œã‚¨ã‚¯ã‚»ãƒ«ã§ä½œæˆã—ãŸã‚°ãƒ©ãƒ•ã‚’ç”»åƒã¨ã—ã¦è²¼ã‚Šä»˜ã‘ã€ã¨ã„ã£ãŸã€æ‰‹ä½œæ¥æ„Ÿã‚ãµã‚Œã‚‹ã‚‚ã®ã ã£ãŸã€‚ ã ãŒã€æ˜¨å¹´æœ«ã«Google Chart APIãŒç™»å ´ã—ã¦ä»¥é™ã€ã•ã¾ã–ã¾ãªã‚µãƒ¼ãƒ“ã‚¹ã‚„ç‹¬è‡ªAPIãŒå¢—åŠ ã—ã€é¸æŠžè‚¢ãŒã‚°ãƒƒã¨å¢—ãˆã¦ããŸã€‚ç„¡æ–™ã§åˆ©ç”¨ã§ãã‚‹
snaoki709 2008/12/13
ã‚¨ã‚¯ã‚»ãƒ«

ãƒ‘ãƒ¯ãƒ¼ãƒã‚¤ãƒ³ãƒˆ

ãƒãƒ£ãƒ¼ãƒˆ
ãƒªãƒ³ã‚¯
ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ç°¡å˜ãªãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ | ã‚³ãƒªã‚¹
Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã‹ã‚‰ã€æ¡ä»¶ä»˜ãæ›¸å¼ã‚’åˆ©ç”¨ã—ã¦ã€ã‚¨ã‚¯ã‚»ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹5ã¤ã®ãƒ†ã‚¯ãƒ‹ãƒƒã‚¯ã‚’ç´¹ä»‹ã—ã¾ã™ã€‚ Learn Cool Microsoft Excel Conditional Formatting Tricks ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ æ¡ä»¶ä»˜ãæ›¸å¼ã‚’ä½¿ç”¨ã—ãŸã‚¬ãƒ³ãƒˆãƒãƒ£ãƒ¼ãƒˆ ã‚»ãƒ«å†…ã«é…ç½®ã™ã‚‹ã‚°ãƒ©ãƒ• ãƒŸã‚¹ã‚„ã‚¨ãƒ©ãƒ¼ãƒ»ãƒ‡ãƒ¼ã‚¿æ¬ è½ãªã©ã®ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤º ç›´æ„Ÿçš„ã«æŠŠæ¡ã§ãã‚‹ãƒ‡ãƒ¼ã‚¿ãƒ†ãƒ¼ãƒ–ãƒ« [ad#ad-2] ã‚¨ã‚¯ã‚»ãƒ«ãƒ‡ãƒ¼ã‚¿ã¯ã€Chandoo.orgã®ã‚¨ãƒ³ãƒˆãƒªãƒ¼ã®ä¸€ç•ªä¸‹ã‹ã‚‰ãƒ€ã‚¦ãƒ³ãƒãƒ¼ãƒ‰ã§ãã¾ã™ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ã®æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’ãƒã‚¤ãƒ©ã‚¤ãƒˆ ãƒ†ãƒ¼ãƒ–ãƒ«ã®ãƒ‡ãƒ¼ã‚¿ã‚’è¦‹ã‚„ã™ãã™ã‚‹ãŸã‚ã«ã€æ¨ªåˆ—ãƒ»ç¸¦åˆ—ã‚’äº¤äº’ã«ãƒã‚¤ãƒ©ã‚¤ãƒˆè¡¨ç¤ºã«ã—ã¾ã™ã€‚ ãƒã‚¤ãƒ©ã‚¤ãƒˆã«ã™ã‚‹ãƒ†ãƒ¼ãƒ–ãƒ«å…¨ä½“ã‚’é¸æŠžã—ã¾ã™ã€‚ ãƒ¡ãƒ‹ãƒ¥ãƒ¼ã‚ˆã‚Šã€[æ›¸å¼] - [æ¡ä»¶ä»˜ãæ›¸å¼] ã‚’é¸æŠžã€‚ ã€Œæ•°å¼ã€ã‚’é¸æŠžã—ã€ã€Œ=MOD(ROW(),2)=0ã€ã‚’å…¥åŠ›ã—
snaoki709 2008/12/13
ã‚¨ã‚¯ã‚»ãƒ«ã®ä½¿ã„æ–¹ã€‚å‚è€ƒã«ãªã‚‹ã€‚

ã‚¨ã‚¯ã‚»ãƒ«

å‚™å¿˜éŒ²

ä¼ç”»æ›¸

ãƒ‘ãƒ¯ãƒ¼ãƒã‚¤ãƒ³ãƒˆ
ãƒªãƒ³ã‚¯
1