[B! æ¡ä»¶] bluegoat511545ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

bluegoat511545 id:bluegoat511545

æ¡ä»¶ã«é–¢ã™ã‚‹bluegoat511545ã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (4)

${{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}}

æµœè¾ºã«å¤§é‡ã®éšãŒæ‰“ã¡ä¸ŠãŒã‚‹â€¦æ±äº¬ãƒ»ä¸‰å®…å³¶ - ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ãƒ‹ãƒ¥ãƒ¼ã‚¹
æä¾›ç¤¾ã®éƒ½åˆã«ã‚ˆã‚Šã€å‰Šé™¤ã•ã‚Œã¾ã—ãŸã€‚ é–¢é€£ãƒ‹ãƒ¥ãƒ¼ã‚¹ ãƒ©ãƒ³ã‚ãƒ³ã‚° ç·åˆ å›½å†… æ”¿æ²» æµ·å¤– çµŒæ¸ˆ IT ã‚¹ãƒãƒ¼ãƒ„ èŠ¸èƒ½ å¥³å
bluegoat511545 2021/02/15
ã€Œæœ€å¤§çž¬é–“é¢¨é€Ÿï¼’ï¼‘ï¼Žï¼–ãƒ¡ãƒ¼ãƒˆãƒ«ã‚’è¨˜éŒ²ã—ã¾ã—ãŸã€‚ã€ã“ã®å°è©žã¯â€¦ ã‚‚ã—ã‹ã—ã¦ä½•ã‹çŸ¥ã£ã¦ã‚‹ã®ã‹ãªï¼Ÿ ã ã£ã¦ã€å°é¢¨æ¥ã¦ã‚‚éšãŒã“ã‚“ãªé¢¨ã«ä¸ŠãŒã£ãŸã“ã¨èžã„ãŸã“ã¨ãªã„ã§ã™ã—ã€å’ŒæŒå±±ã®ç›´ä¸‹åœ°éœ‡ã¯ç¶šãã—æ ªä¾¡ã¯3ä¸‡è¶Šãˆã‚‹ã—â€¦

æ°—è±¡åº

åœ°éœ‡

å‰è§¦ã‚Œ

ãƒ”ãƒ¼ã‚¹ãŒãƒãƒžã‚‹

æ¡ä»¶

ã‚¬ã‚¯ãƒ–ãƒ«

å‰éœ‡

å—æµ·ãƒˆãƒ©ãƒ•

æ€–ã„

ã‚ªãƒªãƒ³ãƒ”ãƒƒã‚¯
ãƒªãƒ³ã‚¯
ã€Œã¾ãšã€ãŠæ‰‹å…ƒã®è³‡æ–™ã‚’å¾¡è¦§ãã ã•ã„ã€ã§å§‹ã¾ã‚‹ä¼šè°ãŒè‡´å‘½çš„ã«ãƒ€ãƒ¡ãªç†ç”±
ã€Œè„±ãƒ€ãƒ¡ä¼šè°ã€ã®å®Ÿç¾ã«å‘ã‘ã€ä¼šè°ã®åŸºç¤Žã‚’è§£èª¬ã™ã‚‹ã“ã®é€£è¼‰ã€‚åˆå›žã§ã¯ã€Œä¼šè°ã®4ã¤ã®ãƒ•ã‚§ãƒ¼ã‚ºã€ã¨ã€Œ8ã¤ã®åŸºæœ¬å‹•ä½œã€ã®å…¨ä½“åƒã‚’ã€2å›žç›®ã¯åŸºæœ¬å‹•ä½œã®1ã¤ç›®ã€Œä¼šè°ã®çµ‚äº†æ™‚ã«ã€Žæ±ºã¾ã£ãŸã“ã¨ã€ã€Žã‚„ã‚‹ã¹ãã“ã¨ã€ã‚’ç¢ºèªã™ã‚‹ã€ã‚’ç´¹ä»‹ã—ãŸã€‚ä»Šå›žã¯ã€åŸºæœ¬å‹•ä½œã®2ã¤ç›®ã¨ãªã‚‹ã€Œä¼šè°ã®é–‹å§‹æ™‚ã«ã€ã€Žä¼šè°ã®çµ‚äº†æ¡ä»¶ã€ã‚’ç¢ºèªã™ã‚‹ã€ã«ã¤ã„ã¦è§£èª¬ã—ã‚ˆã†ã€‚
bluegoat511545 2019/06/06
å¤šé‡ä¸‹è«‹ã‘ãªãŒã‚‰ã‚‚å¤§ä¼æ¥ã§ä¼šè°ã«å‡ºã•ã›ã¦é ‚ã„ãŸè‡ªåˆ†ã¨ã—ã¦ã¯ã€æ—¥æœ¬ã§ã¯ã‚‚ã†å¾¡é¦´æŸ“ã¿ã®å£é å¥ã§ã™ã^^; ä¼šè°ï¼ã€Œä½•ã‹ã‚’æ±ºã‚ã‚‹ã€å ´ã§ã¯ãªãã€"ã‚¨ãƒ“ãƒ‡ãƒ³ã‚¹"ã®å…±æœ‰ã‚„"å…¬é–‹å‡¦åˆ‘"ã«ä½¿ã£ã¦ã„ã‚‹ä¼šç¤¾ãŒã»ã¨ã‚“ã©ã§ã—ãŸã€‚

ä¼šè°

ä»•äº‹

çµ‚äº†

æ¡ä»¶

åƒãæ–¹æ”¹é©

ç”Ÿç”£æ€§

ç„¡é§„

åŠ¹çŽ‡

ç¤¾ä¼š
ãƒªãƒ³ã‚¯
æ—¥æœ¬é›»ç”£ãƒ»æ°¸å®ˆé‡ä¿¡æ°ãŒè¬›æ¼”ã€Œé€Ÿãå¼å½“é£Ÿã¹ã‚‰ã‚Œã‚‹äººã»ã©å„ªç§€ã€ - ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ãƒ‹ãƒ¥ãƒ¼ã‚¹
by ãƒ©ã‚¤ãƒ–ãƒ‰ã‚¢ãƒ‹ãƒ¥ãƒ¼ã‚¹ç·¨é›†éƒ¨ ã–ã£ãã‚Šè¨€ã†ã¨ æ—¥æœ¬é›»ç”£ã®æ°¸å®ˆé‡ä¿¡ä¼šé•·å…¼ç¤¾é•·ãŒ25æ—¥ã€äº¬éƒ½å¦åœ’å¤§ã§è¬›æ¼”ã—ãŸ æŽ¡ç”¨è©¦é¨“ã§ã¯å¼å½“ã‚’æ—©ãé£Ÿã¹ãŸå¦ç”Ÿã‹ã‚‰æŽ¡ç”¨ã—ãŸã“ã¨ãŒã‚ã‚‹ã¨èª¬æ˜Ž é€Ÿãé£Ÿã¹ã‚‹äººã¯ã€ä»•äº‹ãŒã§ãã‚‹æ¡ä»¶ã®æ±ºæ–åŠ›ã¨è¡Œå‹•åŠ›ãŒå‚™ã‚ã£ã¦ã„ã‚‹ã¨ã—ãŸ æä¾›ç¤¾ã®éƒ½åˆã«ã‚ˆã‚Šã€å‰Šé™¤ã•ã‚Œã¾ã—ãŸã€‚ æ¦‚è¦ã®ã¿æŽ²è¼‰ã—ã¦ãŠã‚Šã¾ã™ã€‚ é–¢é€£ãƒ‹ãƒ¥ãƒ¼ã‚¹ ãƒ©ãƒ³ã‚ãƒ³ã‚° ç·åˆ å›½å†… æ”¿æ²» æµ·å¤– çµŒæ¸ˆ IT ã‚¹ãƒãƒ¼ãƒ„ èŠ¸èƒ½ å¥³å
bluegoat511545 2017/11/26
æ£ã«ç¤¾ç•œã®é¡ï¼ç³–å°¿ç—…ã¸ã¾ã£ã—ãã‚‰m(_ _)m

ä»•äº‹

æ¡ä»¶

é¢æŽ¥

è©¦é¨“

ä¼šç¤¾

ãƒ–ãƒ©ãƒƒã‚¯

ä¼æ¥

ç¤¾ç•œ
ãƒªãƒ³ã‚¯
IFé–¢æ•°ã¨è¤‡æ•°æ¡ä»¶--Excelãƒ»ã‚¨ã‚¯ã‚»ãƒ«
è¤‡æ•°ã®æ¡ä»¶ã‚’åˆ¤å®šã§ãã‚‹ANDé–¢æ•°ã¨ORé–¢æ•°ã€‚ ã§ã‚‚åˆ¤å®šçµæžœãŒã€ŒTRUEã€ã¨ã€ŒFALSEã€ã§è¡¨ç¤ºã•ã‚Œã‚‹ã®ã¯ãƒ„ãƒ©ã‚¤ï¼ æ¡ä»¶ã«è©²å½“ã—ã¦ã„ãŸå ´åˆã«ã¯ã€Œé”æˆã€ã€ãã†ã˜ã‚ƒãªã„å ´åˆã«ã¯ã€Œæœªé”æˆã€ã¨ã„ã£ãŸé¢¨ã« è‡ªåˆ†ã®å¥½ã¿ã®è¨€è‘‰ã§è¡¨ç¤ºã•ã›ãŸã„å ´åˆã«ã¯ã‚„ã¯ã‚ŠIFé–¢æ•°ã‚’ä½¿ç”¨ã—ã¾ã™ã€‚ ã¡ãªã¿ã«ã€IFé–¢æ•°ã®è€ƒãˆæ–¹ã¯ã“ã†ã§ã—ãŸã€‚ ãã—ã¦ä»Šå›žã¯ã“ã‚“ãªè¨å®šã‚’ã—ã¦ã¿ã¾ã™ã€‚ ã¾ãšã¯åˆ¤å®šã‚’è¡¨ç¤ºã•ã›ãŸã„å…ˆé ã®ã‚»ãƒ«ã‚’é¸æŠžã—ã€IFé–¢æ•°ã‚’é¸ã³ã¾ã™ã€‚ ã¨ã“ã‚ãŒï¼ ä¸€ç•ªæœ€åˆã®å¼•æ•°ï¼»è«–ç†å¼ï¼½ã§æ—©é€Ÿå•é¡ŒãŒèµ·ã“ã‚Šã¾ã™ï¼ ï¼»è«–ç†å¼ï¼½ã¯æ¡ä»¶ã¨ãªã‚‹æ•°å¼ã‚’å…¥åŠ›ã™ã‚‹å ´æ‰€ã§ã™ã€‚ ã§ã™ãŒã“ã®æ¬„ã¯1ã¤ã—ã‹ã‚ã‚Šã¾ã›ã‚“ï¼ ãã†ã€ä»Šå›žã®ã‚ˆã†ã«è¤‡æ•°ã®æ¡ä»¶ã‚’å…¥åŠ›ã—ãŸã„å ´åˆã«ã¯ã“ã®ã¾ã¾ã§ã¯å¯¾å¿œã§ããªã„ã®ã§ã™ã€‚ ãã“ã§ï¼æ¡ä»¶ã¨ãªã‚‹æ•°å¼ã‚’è¤‡æ•°å…¥åŠ›ã§ãã‚‹ã‚ˆã†ã€ ï¼»è«–ç†å¼ï¼½æ¬„ã«ANDé–¢æ•°ã¾ãŸã¯ORé–¢æ•°ã‚’å…¥åŠ›ã—ã¦ã„ãã¾ã™ã€‚ ä»Šå›žã®ä¾‹ã§ã¯æ¡ä»¶ã®ä¸¡æ–¹ã‚’æº€ãŸã—ã¦ã„ã‚‹ã‹ã‚’åˆ¤å®šã™ã‚‹ã®ã§AND
bluegoat511545 2017/09/27
Excelã®ifæ–‡ã«å¯èƒ½æ€§ãŒé–‹ã‘ã¾ã™(^^)

Excel

é–¢æ•°

if

æ¡ä»¶
ãƒªãƒ³ã‚¯
1