<span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">엑셀을 배워본적이 없어서 인터넷에서 간간히 찾아서 쓴 함수가 지금 </span> <div><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">=</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">ROUNDDOWN</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">(</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">(</span><span style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;color:#f7981d;">N14</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">*</span><span style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;color:#7e3794;">N5</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">*</span><span style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;color:#11a9cc;">N11</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">-</span><span style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;color:#a61d4c;">N8</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">)</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">/</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">(</span><span style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;color:#4285f4;">N10</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">)</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">,</span><span class="number" style="color:#1155cc;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">2</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">)</span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;"> </span><span class="default-formula-text-color" style="font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">&</span><span class="string" style="color:#008000;font-family:Inconsolata, monospace, arial, sans, sans-serif;font-size:14px;line-height:normal;white-space:pre-wrap;">"문자"</span></div> <div>이라는 함수를 작성했는데 N14,N5,N11.N10열에 숫자 뿐만아니라 화폐단위처럼 "(숫자)원" 이런 문자가 같이 포함되있는데</div> <div>해당 셀에서 숫자만 뽑아올수있는 함수는 없나요..??</div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.