엑셀 질문입니다.

<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_100.gif" width="22" height="15" class="grade" alt="내공100" 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;">질문 29건 질문마감률</span><span style="margin: 0px -1px 0px 4px; padding: 0px; color: rgb(44, 95, 153);">83.9%</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.24. 11:08</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);">25</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;"><p><img name="img_a9e6a58e8ff9e6ea0dedf86f65ebd297" class="_rolling_0" alt="" width="620" height="474" src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fkinimage.naver.net%2F20160324_276%2F1458785997013kC5gb_JPEG%2F%25C1%25F6%25BD%25C4%25C0%25CE.png%3Ftype%3Dw620" style="margin: 0px; padding: 0px; border: 0px; cursor: pointer;"> 수신기관명에 내용이 있으면 통수에 숫자 1이 자동으로 써지게 하는 함수 없을까요?</p><p><br style="margin: 0px; padding: 0px;"></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=248666681&page=1#" id="cmtstr_0" class="btn _write_opinion _param('kin,10202,248666681,0,KxtrKAtdKqKwFo2qFZvZFA2rFoMraAuGpzkRD4vGF029E0-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;">의견 <span style="margin: 0px; padding: 0px; color: rgb(235, 51, 51); font-size: 14px; vertical-align: bottom;">1</span></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=248666681&page=1#" class="btn opinion _metoo_wonder disable _param('10202,248666681,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=248666681&page=1#" class="_statement _ros _param('question,10202,248666681,KxtrKAtdKqKwFo2qFZvZFA2rFoMraAuGpzkRD4vGF029E0-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="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=248666681&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);">52</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.24. 11:12</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;">=if(isblank(A5),0,1)<div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">E5셀에 붙여넣기 해보세용</div><div><br></div></div></div></div></div></div><p><br></p>