이 엑셀 계산문제 어떻게 푸나요?

<div id="qna_detail_question" class="qna_detail_question" style="margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, 굴림, Gulim, Helvetica, 'Apple SD Gothic Neo', 새굴림, 'New Gulim', sans-serif; line-height: 14px;"><div class="end_question _end_wrap_box" style="margin: 0px; padding: 0px; width: 679px; background: url("http://static.naver.net/kin/09renewal/bg_end_q.gif") repeat-x;"><div class="end_tit" style="margin: 0px; padding: 0px 0px 35px; position: relative; clear: both; width: 679px; z-index: 10 !important;"><div class="tit_ico" style="margin: 0px; padding: 0px 7px 0px 0px; float: left;"><img src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fstatic.naver.net%2Fkin%2F09renewal%2Fblank.gif" width="1" height="1" class="question" alt="질문" style="margin: 33px 0px 0px 25px; padding: 0px; border: 0px; width: 47px; height: 47px; background: url("http://static.naver.com/kin/09renewal/bg_sprite_endico_141222.gif") no-repeat;"></div><div class="tit_cont _endTitle" style="margin: 0px; padding: 34px 0px 0px; float: left;"><h3 class="_endTitleText" style="margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 4px !important; padding-left: 0px; width: 410px; color: rgb(16, 16, 16); font-size: 16px; line-height: 21px; letter-spacing: -1px; word-break: break-all; word-wrap: break-word;">이 엑셀 계산문제 어떻게 푸나요? <img src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fstatic.naver.net%2Fkin%2F09renewal%2Fexppoint%2Fico_capa_60.gif" width="22" height="15" class="grade" alt="내공60" style="margin: 0px; padding: 0px 1px 0px 0px; border: 0px; position: relative; top: 2px; vertical-align: top;"></h3><dl style="margin: 0px; padding: 0px; overflow: hidden; width: 420px; line-height: 19px;"><dt style="margin: 0px 3px 0px 0px; padding: 5px 8px 5px 24px; display: inline; color: rgb(66, 66, 66); font-size: 11px; background: url("http://static.naver.net/kin/09renewal/ico_q_sta.gif") 1px 0px no-repeat;">비공개 </dt><dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;"><span style="margin: 0px; padding: 0px; color: rgb(121, 121, 121); letter-spacing: -1px;">질문 58건 질문마감률</span><span style="margin: 0px -1px 0px 4px; padding: 0px; color: rgb(44, 95, 153);">54.6%</span></dd> <dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;">2016.03.25. 09:57</dd></dl></div><div class="recom_q" style="margin: 0px; padding: 27px 0px 0px; float: right; width: 175px; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(233, 234, 228); text-align: center;"><div class="lvarea" style="margin: 0px; padding: 5px 0px 4px;"><strong class="blind" style="margin: 0px 0px 0px -6px; padding: 0px 0px 0px 18px; position: absolute; top: 0px; left: 0px; width: 0px; height: 0px; overflow: hidden; visibility: hidden; font-size: 21px; line-height: 21px; display: inline-block; font-family: Tahoma, Helvetica; color: rgb(245, 72, 18); background: url("http://static.naver.net/kin/09renewal/sp_recm.gif") -150px 0px no-repeat;"></strong><strong class="_kinupPoint" style="margin: 0px 0px 0px -6px; padding: 0px 0px 0px 18px; display: inline-block; overflow: hidden; font-size: 21px; font-family: Tahoma, Helvetica; color: rgb(245, 72, 18); line-height: 21px; background: url("http://static.naver.net/kin/09renewal/sp_recm.gif") -150px 0px no-repeat;">0</strong></div><dl style="margin: 0px; padding: 4px 0px 0px; font-size: 11px;"><dt style="margin: 0px; padding: 0px; display: inline; color: rgb(120, 120, 120); letter-spacing: -1px;">답변</dt> <dd style="margin: 0px; padding: 0px; display: inline; color: rgb(66, 66, 66);"><strong style="margin: 0px 4px 0px 0px; padding: 0px 9px 0px 0px; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 100% 0px no-repeat;">1</strong></dd> <dt style="margin: 0px; padding: 0px; display: inline; color: rgb(120, 120, 120); letter-spacing: -1px;">조회</dt> <dd style="margin: 0px; padding: 0px; display: inline; color: rgb(66, 66, 66);">30</dd></dl></div></div><div id="contents_layer_0" style="margin: 0px; padding: 0px;"><div class="end_content _endContents" style="margin: 0px auto; padding: 0px 0px 54px; width: 623px; overflow: hidden; color: rgb(64, 64, 64); font-family: gulim, sans-serif; font-size: 13px; line-height: 1.7; word-break: break-all; word-wrap: break-word;"><div class="_endContentsText" style="margin: 0px; padding: 0px;"><table border="0" cellspacing="0" cellpadding="0" width="333" style="margin: 0px; padding: 0px; width: 250pt; border-collapse: collapse;"><colgroup style="margin: 0px; padding: 0px;"><col width="80" style="margin: 0px; padding: 0px; width: 60pt;"><col width="80" style="margin: 0px; padding: 0px; width: 60pt;"><col width="93" style="margin: 0px; padding: 0px; width: 70pt;"><col width="80" style="margin: 0px; padding: 0px; width: 60pt;"></colgroup><tbody style="margin: 0px; padding: 0px;"><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td height="22" width="80" style="margin: 0px; padding: 0px; border: rgb(240, 240, 240); width: 60pt; height: 16.5pt; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">(계산3)</font></td><td width="80" style="margin: 0px; padding: 0px; border: rgb(240, 240, 240); width: 60pt; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;"></font></td><td width="93" style="margin: 0px; padding: 0px; border: rgb(240, 240, 240); width: 70pt; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;"></font></td><td width="80" style="margin: 0px; padding: 0px; border: rgb(240, 240, 240); width: 60pt; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;"></font></td></tr><tr height="23" style="margin: 0px; padding: 0px; height: 17.25pt;"><td class="xl76" height="23" colspan="4" style="margin: 0px; padding: 0px; border: rgb(240, 240, 240); height: 17.25pt; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;"><strong style="margin: 0px; padding: 0px;">태안정보 사원 명단</strong></font></td></tr><tr height="10" style="margin: 0px; padding: 0px; height: 7.5pt;"><td height="10" style="margin: 0px; padding: 0px; border: rgb(240, 240, 240); height: 7.5pt; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;"><strong style="margin: 0px; padding: 0px;"></strong></font></td><td style="margin: 0px; padding: 0px; border: rgb(240, 240, 240); background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;"><strong style="margin: 0px; padding: 0px;"></strong></font></td><td style="margin: 0px; padding: 0px; border: rgb(240, 240, 240); background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;"><strong style="margin: 0px; padding: 0px;"></strong></font></td><td style="margin: 0px; padding: 0px; border: rgb(240, 240, 240); background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;"><strong style="margin: 0px; padding: 0px;"></strong></font></td></tr><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td class="xl65" height="22" style="margin: 0px; padding: 0px; border-color: rgb(196, 215, 155) rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; border-left-width: 0.5pt; border-left-style: solid; height: 16.5pt; border-top-width: 0.5pt; border-top-style: solid; background-color: rgb(155, 187, 89);"><strong style="margin: 0px; padding: 0px;"><font size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">번호</font></strong></td><td class="xl66" style="margin: 0px; padding: 0px; border-color: rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-top-width: 0.5pt; border-top-style: solid; background-color: rgb(155, 187, 89);"><strong style="margin: 0px; padding: 0px;"><font size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">사원명</font></strong></td><td class="xl66" style="margin: 0px; padding: 0px; border-color: rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-top-width: 0.5pt; border-top-style: solid; background-color: rgb(155, 187, 89);"><strong style="margin: 0px; padding: 0px;"><font size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">입사년일</font></strong></td><td class="xl67" style="margin: 0px; padding: 0px; border-color: rgb(196, 215, 155) rgb(196, 215, 155) rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-top-width: 0.5pt; border-top-style: solid; border-right-width: 0.5pt; border-right-style: solid; background-color: rgb(155, 187, 89);"><strong style="margin: 0px; padding: 0px;"><font size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">진급대상</font></strong></td></tr><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td class="xl68" height="22" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; border-left-width: 0.5pt; border-left-style: solid; height: 16.5pt; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">20101</font></td><td class="xl69" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">민길동</font></td><td class="xl70" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">2003-03-10</font></td><td class="xl71" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-right-width: 0.5pt; border-right-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">　</font></td></tr><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td class="xl72" height="22" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; border-left-width: 0.5pt; border-left-style: solid; height: 16.5pt; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">20102</font></td><td class="xl73" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">안길동</font></td><td class="xl74" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">1993-05-07</font></td><td class="xl75" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-right-width: 0.5pt; border-right-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">　</font></td></tr><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td class="xl68" height="22" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; border-left-width: 0.5pt; border-left-style: solid; height: 16.5pt; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">20103</font></td><td class="xl69" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">권길동</font></td><td class="xl70" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">2003-11-20</font></td><td class="xl71" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-right-width: 0.5pt; border-right-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">　</font></td></tr><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td class="xl72" height="22" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; border-left-width: 0.5pt; border-left-style: solid; height: 16.5pt; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">20104</font></td><td class="xl73" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">추길동</font></td><td class="xl74" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">1995-03-29</font></td><td class="xl75" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-right-width: 0.5pt; border-right-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">　</font></td></tr><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td class="xl68" height="22" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; border-left-width: 0.5pt; border-left-style: solid; height: 16.5pt; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">20105</font></td><td class="xl69" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">태길동</font></td><td class="xl70" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">1997-03-15</font></td><td class="xl71" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-right-width: 0.5pt; border-right-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">　</font></td></tr><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td class="xl72" height="22" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; border-left-width: 0.5pt; border-left-style: solid; height: 16.5pt; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">20106</font></td><td class="xl73" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">기길동</font></td><td class="xl74" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">2002-09-10</font></td><td class="xl75" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-right-width: 0.5pt; border-right-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">　</font></td></tr><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td class="xl68" height="22" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; border-left-width: 0.5pt; border-left-style: solid; height: 16.5pt; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">20107</font></td><td class="xl69" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">이길동</font></td><td class="xl70" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">1999-04-06</font></td><td class="xl71" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-right-width: 0.5pt; border-right-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">　</font></td></tr><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td class="xl72" height="22" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; border-left-width: 0.5pt; border-left-style: solid; height: 16.5pt; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">20108</font></td><td class="xl73" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">윤길동</font></td><td class="xl74" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">1988-03-29</font></td><td class="xl75" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-right-width: 0.5pt; border-right-style: solid; background-color: transparent;"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">　</font></td></tr><tr height="22" style="margin: 0px; padding: 0px; height: 16.5pt;"><td class="xl68" height="22" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; border-left-width: 0.5pt; border-left-style: solid; height: 16.5pt; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">20109</font></td><td class="xl69" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">김길동</font></td><td class="xl70" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(240, 240, 240) rgb(196, 215, 155); border-bottom-width: 0.5pt; border-bottom-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">1995-10-10</font></td><td class="xl71" style="margin: 0px; padding: 0px; border-color: rgb(240, 240, 240) rgb(196, 215, 155) rgb(196, 215, 155) rgb(240, 240, 240); border-bottom-width: 0.5pt; border-bottom-style: solid; border-right-width: 0.5pt; border-right-style: solid; background-color: rgb(235, 241, 222);"><font color="#000000" size="3" face="맑은 고딕" style="margin: 0px; padding: 0px;">　</font></td></tr></tbody></table><p> </p><p>입사일이 1999년 이전이면 진급대상에 '해당'을 표시하고 그렇지 않으면 빈 공백으로 처리하세요.</p><p> </p><p> </p><p>부탁드립니다</p></div></div><div id="qna_detail_question_commentAndMenu" style="margin: 0px; padding: 0px;"><div class="end_qna_link _end_qna_link" style="margin: 0px; padding: 0px 0px 35px; position: relative; clear: both; width: 679px; z-index: 10;"><div class="recom_a" style="margin: 0px 0px 0px 28px; padding: 0px;"><div class="btn_wrap" style="margin: 0px; padding: 0px; display: inline-block; position: relative; float: left;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248730570&page=1#" id="cmtstr_0" class="btn _write_opinion _param('kin,10202,248730570,0,KxtrKAtdKqt9FovqFZvZFA2XKqg9FqgGpzkRD4vGF029E0-HLvpK3dw6xt==') " style="margin: 0px 10px 0px 0px; padding: 9px 0px 7px; display: inline-block; overflow: hidden; width: 88px; height: 14px; border-top-width: 1px; border-right-width: 1px; border-left-width: 1px; border-style: solid; border-color: rgb(208, 208, 208); text-align: center; color: rgb(0, 0, 0); font-weight: bold;">의견 쓰기</a></div><div class="btn_wrap" style="margin: 0px; padding: 0px; display: inline-block; position: relative; float: left;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248730570&page=1#" class="btn opinion _metoo_wonder disable _param('10202,248730570,PC') _clickcode:end.metoo" style="margin: 0px 10px 0px 0px; padding: 9px 12px 7px; float: left; display: inline-block; overflow: hidden; width: auto; height: 14px; border-top-width: 1px; border-right-width: 1px; border-left-width: 1px; border-style: solid; border-color: rgb(208, 208, 208); text-align: center; color: rgb(177, 177, 177); font-weight: bold; cursor: default;">나도 궁금해요<span style="margin: 0px; padding: 0px; color: rgb(235, 51, 51); font-size: 14px; vertical-align: bottom;"></span></a></div></div><ul class="etc" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; padding: 0px 18px 0px 0px; position: absolute; bottom: 41px; right: 0px;"><li class="first" style="margin: 0px; padding: 0px 9px; list-style: none; position: relative; display: inline; float: left; background: none;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248730570&page=1#" class="_statement _ros _param('question,10202,248730570,KxtrKAtdKqt9FovqFZvZFA2XKqg9FqgGpzkRD4vGF029E0-HLvpK3dw6xt==')" style="margin: 0px; padding: 0px; display: inline-block; color: rgb(44, 44, 44); line-height: 16px;">신고</a></li></ul></div><div class="_wrap_iframe" style="margin: 0px; padding: 0px;"></div></div><div class="end_q_bottom" style="margin: -9px 0px 0px; padding: 0px 0px 35px; clear: both; width: 679px; border-top-width: 1px; border-top-style: solid; border-top-color: rgb(243, 243, 243);"><p style="margin-top: 31px; padding-left: 44px; position: relative; float: left; color: rgb(118, 118, 118); line-height: 19px;"><span class="ico" style="margin: 0px; padding: 0px; display: block; position: absolute; top: 3px; left: 28px; width: 12px; height: 12px; background: url("http://static.naver.net/kin/09renewal/bg_sprite_ico_140811.gif") 0px -1740px no-repeat;"></span>질문자 채택된 경우, <span style="margin: 0px; padding: 0px; color: rgb(27, 143, 0);">추가 답변 등록이 불가</span>합니다.</p></div></div></div></div><div id="ad_randicon" style="margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, 굴림, Gulim, Helvetica, 'Apple SD Gothic Neo', 새굴림, 'New Gulim', sans-serif; line-height: 14px; position: absolute; z-index: 1000; top: 67px; left: 529px; width: 100px; height: 0px;"></div><div id="qna_detail_answerList_best" class="qna_detail_answerList" style="margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, 굴림, Gulim, Helvetica, 'Apple SD Gothic Neo', 새굴림, 'New Gulim', sans-serif; line-height: 14px;"><a name="answer1" style="margin: 0px; padding: 0px;"><span class="blind a_initial" style="margin: 0px; padding: 0px; position: relative; top: 0px; left: 0px; width: 0px; height: 0px; overflow: hidden; visibility: hidden; font-size: 0px; line-height: 0;"></span></a><div class="end_answer _end_wrap_box" style="margin: 0px; padding: 0px; position: relative; width: 679px; border-top-width: 1px !important; border-top-style: solid !important; border-top-color: rgb(197, 197, 197) !important; background: url("http://static.naver.net/kin/09renewal/bg_end_a.gif") repeat-x;"><div class="end_tit" style="margin: 0px; padding: 0px 0px 35px; position: relative; clear: both; width: 679px; z-index: 5 !important;"><div class="tit_ico" style="margin: 0px; padding: 0px 7px 0px 0px; float: left;"><img src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fstatic.naver.net%2Fkin%2F09renewal%2Fblank.gif" width="1" height="1" class="choose_q" alt="질문자 채택" style="margin: -1px 0px -16px 12px; padding: 0px; border: 0px; width: 73px; height: 90px; background: url("http://static.naver.com/kin/09renewal/bg_sprite_endico_141222.gif") 0px -700px no-repeat;"></div><div class="tit_cont _endTitle" style="margin: 0px; padding: 34px 0px 0px; float: left;"><h3 style="margin: 0px; padding: 0px 0px 5px; width: 410px; color: rgb(16, 16, 16); font-size: 14px; line-height: 21px; letter-spacing: -1px; word-break: break-all; word-wrap: break-word;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248730570&page=1#" class="_user_id _popup" style="margin: 0px; padding: 0px;"><span style="margin: 0px; padding: 0px; color: rgb(38, 142, 0);">합격다드림(demzi)</span></a>님의 답변입니다.</h3><dl style="margin: 0px; padding: 0px; overflow: hidden; width: 420px; line-height: 19px;"><dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;"><span style="margin: 0px; padding: 0px; color: rgb(121, 121, 121); letter-spacing: -1px;">채택답변수</span><span style="margin: 0px -1px 0px 4px; padding: 0px; color: rgb(44, 95, 153);">56</span></dd> <dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;">2016.03.25. 10:00</dd></dl></div></div><div class="end_a_thanks" style="margin: 0px auto 20px; padding: 0px; clear: both; width: 623px; overflow: hidden; border: 1px solid rgb(240, 240, 240); background: rgb(248, 248, 248);"><h4 style="margin: 0px; padding: 18px 0px 0px 15px; float: left; width: 75px; color: rgb(38, 142, 0); letter-spacing: -1px;">질문자 인사</h4><p style="padding-top: 15px; padding-bottom: 15px; float: left; width: 500px; color: rgb(48, 48, 48); line-height: 19px;">정말 친절한 답변 감사드립니다.</p></div><div id="contents_layer_1" style="margin: 0px; padding: 0px; position: relative; z-index: 0;"><div class="end_content _endContents" style="margin: 0px auto; padding: 0px 0px 54px; width: 623px; overflow: hidden; color: rgb(64, 64, 64); font-family: gulim, sans-serif; font-size: 13px; line-height: 1.7; word-break: break-all; word-wrap: break-word;"><div class="_endContentsText" style="margin: 0px; padding: 0px;">입사년일이 c1셀에 있다는 가정하에 설명드리겠습니다<div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">민길동의 진급대상 여부 확인</div><div style="margin: 0px; padding: 0px;">=if(year(c2)<=1999,"해당","")</div><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">진급대상에 셀주소를 확인한 뒤 이렇게 넣어보세요</div></div></div></div></div></div><p><br></p>