<div>아래와 같이 비주얼 베이직으로 if 문 구현했는데요.</div> <div> </div> <div>실제로 아래와 같이 입력했을 때 출력값 처럼 나오게 하려고 합니다.</div> <div> </div> <div>입력 값이 0과 1 사이 일경우 1에서 입력한 값을 나눠서 출력 값도 같은 비율로 나눌거구요..</div> <div> </div> <div>근데 뭘 입력하던지간에... 출력이 0이 나오네요? ㅠㅠ</div> <div> </div> <div>어느 부분을 수정해야 될까요?</div> <div> </div><font size="3"></font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font><font size="3"> </font> <table width="144" style="width:108pt;border-collapse:collapse;" border="0" cellspacing="0" cellpadding="0"><colgroup><col width="72" style="width:54pt;" span="2"></colgroup><tbody><tr height="22" style="height:16.5pt;"><td width="72" height="22" class="xl63" style="border:0px rgb(0,0,0);width:54pt;height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">입력</font></td> <td width="72" class="xl63" style="border:0px rgb(0,0,0);width:54pt;background-color:transparent;"><font face="맑은 고딕" size="3">출력</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl63" style="border:0px rgb(0,0,0);height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">0</font></td> <td class="xl63" style="border:0px rgb(0,0,0);background-color:transparent;"><font face="맑은 고딕" size="3">0</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl63" style="border:0px rgb(0,0,0);height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">1</font></td> <td class="xl63" style="border:0px rgb(0,0,0);background-color:transparent;"><font face="맑은 고딕" size="3">0.00058</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl63" style="border:0px rgb(0,0,0);height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">20</font></td> <td class="xl63" style="border:0px rgb(0,0,0);background-color:transparent;"><font face="맑은 고딕" size="3">0.00984</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl63" style="border:0px rgb(0,0,0);height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">40</font></td> <td class="xl63" style="border:0px rgb(0,0,0);background-color:transparent;"><font face="맑은 고딕" size="3">0.01969</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl63" style="border:0px rgb(0,0,0);height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">60</font></td> <td class="xl63" style="border:0px rgb(0,0,0);background-color:transparent;"><font face="맑은 고딕" size="3">0.03019</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl63" style="border:0px rgb(0,0,0);height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">80</font></td> <td class="xl63" style="border:0px rgb(0,0,0);background-color:transparent;"><font face="맑은 고딕" size="3">0.04158</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl63" style="border:0px rgb(0,0,0);height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">100</font></td> <td class="xl63" style="border:0px rgb(0,0,0);background-color:transparent;"><font face="맑은 고딕" size="3">0.05417</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl63" style="border:0px rgb(0,0,0);height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">120</font></td> <td class="xl63" style="border:0px rgb(0,0,0);background-color:transparent;"><font face="맑은 고딕" size="3">0.0684</font></td></tr><tr height="22" style="height:16.5pt;"><td height="22" class="xl63" style="border:0px rgb(0,0,0);height:16.5pt;background-color:transparent;"><font face="맑은 고딕" size="3">140</font></td> <td class="xl63" style="border:0px rgb(0,0,0);background-color:transparent;"><font face="맑은 고딕" size="3">0.0846</font></td></tr></tbody></table><div> </div> <div> </div> <div> </div> <div>Public Function 계산식(입력)<br> If 입력 = 0 Then<br> 출력 = 0<br> <br> ElseIf 입력 = 1 Then<br> 출력 = 0.00058<br> <br> ElseIf 입력 = 20 Then<br> 출력 = 0.00984<br> <br> ElseIf 입력 = 40 Then<br> 출력 = 0.0969<br> <br> ElseIf 입력 = 60 Then<br> 출력 = 0.03019<br> <br> ElseIf 입력 = 80 Then<br> 출력 = 0.04158<br> <br> ElseIf 입력 = 100 Then<br> 출력 = 0.05417<br> <br> ElseIf 입력 = 120 Then<br> 출력 = 0.0684<br> <br> ElseIf 입력 = 140 Then<br> 출력 = 0.0846<br> <br> ElseIf 0 < 입력 < 1 Then<br> 출력 = (입력 / 1) * 0.00058<br> <br> ElseIf 1 < 입력 < 20 Then<br> 출력 = (입력 / 20) * 0.00984<br> <br> ElseIf 20 < 입력 < 40 Then<br> 출력 = (입력 / 40) * 0.01969<br> <br> ElseIf 40 < 입력 < 60 Then<br> 출력 = (입력 / 60) * 0.03019<br> <br> ElseIf 60 < 입력 < 80 Then<br> 출력 = (입력 / 80) * 0.04158<br> <br> ElseIf 80 < 입력 < 100 Then<br> 출력 = (입력 / 100) * 0.05417<br> <br> ElseIf 100 < 입력 < 120 Then<br> 출력 = (입력 / 120) * 0.0684<br> <br> ElseIf 120 < 입력 < 140 Then<br> 출력 = (입력 / 140) * 0.0846<br> <br> Else<br> 출력 = (입력 / 140) * 0.0846<br> <br> End If<br> <br>End Function</div> <div> </div>
댓글 분란 또는 분쟁 때문에 전체 댓글이 블라인드 처리되었습니다.