커뮤니티

문의드립니다

프로필 이미지
회원
2016-10-24 09:22:07
86
글번호 103243
답변완료
1 var1 = H-max(C,O); var2 = min(C,O)-L; var3 = H-L; if C > O and var1 >= var3*0.5 and var1 < var3*0.7 Then plot1(H,"검색",CYAN); if C > O and var1 >= var3*0.7 and var1 < var3*0.7 Then plot1(H,"검색",BLUE); if C > O and var2 >= var3*0.5 and var2 < var3*0.7 Then plot1(H,"검색",MAGENTA); if C > O and var2 >= var3*0.7 and var2 < var3*0.7 Then plot1(H,"검색",RED); if C < O and var2 >= var3*0.5 and var2 < var3*0.7 Then plot1(L,"검색",MAGENTA); if C < O and var2 >= var3*0.7 and var2 < var3*0.7 Then plot1(L,"검색",RED); if C < O and var1 >= var3*0.5 and var1 < var3*0.7 Then plot1(L,"검색",CYAN); if C < O and var1 >= var3*0.7 and var1 < var3*0.7 Then plot1(L,"검색",BLUE); 2 var1 = H-max(C,O); var2 = min(C,O)-L; var3 = H-L; if C > O and var1 >= var3*0.5 and var1 < var3*0.7 Then PlotPaintBar(H,L,"강조",CYAN); if C > O and var1 >= var3*0.7 and var1 < var3*0.7 Then PlotPaintBar(H,L,"강조",BLUE); if C > O and var2 >= var3*0.5 and var2 < var3*0.7 Then PlotPaintBar(H,L,"강조",MAGENTA); if C > O and var2 >= var3*0.7 and var2 < var3*0.7 Then PlotPaintBar(H,L,"강조",RED); if C < O and var2 >= var3*0.5 and var2 < var3*0.7 Then PlotPaintBar(H,L,"강조",MAGENTA); if C < O and var2 >= var3*0.7 and var2 < var3*0.7 Then PlotPaintBar(H,L,"강조",RED); if C < O and var1 >= var3*0.5 and var1 < var3*0.7 Then PlotPaintBar(H,L,"강조",CYAN); if C < O and var1 >= var3*0.7 and var1 < var3*0.7 Then PlotPaintBar(H,L,"강조",BLUE); ....................................................................... 50175번 문의글에서 작성해주신 수식입니다. 그런데 50% 이상은 수식표현이 되는데... 70% 이상에서는 수식 표현이 안됩니다. 살펴봐 주세요 감사합니다
검색
답변 1
프로필 이미지

예스스탁 예스스탁 답변

2016-10-24 17:04:16

안녕하세요 예스스탁입니다. 70%에 조건을 잘못지정했습니다. 수정한 식입니다. 1. var1 = H-max(C,O); var2 = min(C,O)-L; var3 = H-L; if C > O and var1 >= var3*0.5 and var1 < var3*0.7 Then plot1(H,"검색",CYAN); if C > O and var1 >= var3*0.7 Then plot1(H,"검색",BLUE); if C > O and var2 >= var3*0.5 and var2 < var3*0.7 Then plot1(H,"검색",MAGENTA); if C > O and var2 >= var3*0.7 Then plot1(H,"검색",RED); if C < O and var2 >= var3*0.5 and var2 < var3*0.7 Then plot1(L,"검색",MAGENTA); if C < O and var2 >= var3*0.7 Then plot1(L,"검색",RED); if C < O and var1 >= var3*0.5 and var1 < var3*0.7 Then plot1(L,"검색",CYAN); if C < O and var1 >= var3*0.7 Then plot1(L,"검색",BLUE); 2 var1 = H-max(C,O); var2 = min(C,O)-L; var3 = H-L; if C > O and var1 >= var3*0.5 and var1 < var3*0.7 Then PlotPaintBar(H,L,"강조",CYAN); if C > O and var1 >= var3*0.7 Then PlotPaintBar(H,L,"강조",BLUE); if C > O and var2 >= var3*0.5 and var2 < var3*0.7 Then PlotPaintBar(H,L,"강조",MAGENTA); if C > O and var2 >= var3*0.7 Then PlotPaintBar(H,L,"강조",RED); if C < O and var2 >= var3*0.5 and var2 < var3*0.7 Then PlotPaintBar(H,L,"강조",MAGENTA); if C < O and var2 >= var3*0.7 Then PlotPaintBar(H,L,"강조",RED); if C < O and var1 >= var3*0.5 and var1 < var3*0.7 Then PlotPaintBar(H,L,"강조",CYAN); if C < O and var1 >= var3*0.7 Then PlotPaintBar(H,L,"강조",BLUE); 즐거운 하루되세요 > alsk 님이 쓴 글입니다. > 제목 : 문의드립니다 > 1 var1 = H-max(C,O); var2 = min(C,O)-L; var3 = H-L; if C > O and var1 >= var3*0.5 and var1 < var3*0.7 Then plot1(H,"검색",CYAN); if C > O and var1 >= var3*0.7 and var1 < var3*0.7 Then plot1(H,"검색",BLUE); if C > O and var2 >= var3*0.5 and var2 < var3*0.7 Then plot1(H,"검색",MAGENTA); if C > O and var2 >= var3*0.7 and var2 < var3*0.7 Then plot1(H,"검색",RED); if C < O and var2 >= var3*0.5 and var2 < var3*0.7 Then plot1(L,"검색",MAGENTA); if C < O and var2 >= var3*0.7 and var2 < var3*0.7 Then plot1(L,"검색",RED); if C < O and var1 >= var3*0.5 and var1 < var3*0.7 Then plot1(L,"검색",CYAN); if C < O and var1 >= var3*0.7 and var1 < var3*0.7 Then plot1(L,"검색",BLUE); 2 var1 = H-max(C,O); var2 = min(C,O)-L; var3 = H-L; if C > O and var1 >= var3*0.5 and var1 < var3*0.7 Then PlotPaintBar(H,L,"강조",CYAN); if C > O and var1 >= var3*0.7 and var1 < var3*0.7 Then PlotPaintBar(H,L,"강조",BLUE); if C > O and var2 >= var3*0.5 and var2 < var3*0.7 Then PlotPaintBar(H,L,"강조",MAGENTA); if C > O and var2 >= var3*0.7 and var2 < var3*0.7 Then PlotPaintBar(H,L,"강조",RED); if C < O and var2 >= var3*0.5 and var2 < var3*0.7 Then PlotPaintBar(H,L,"강조",MAGENTA); if C < O and var2 >= var3*0.7 and var2 < var3*0.7 Then PlotPaintBar(H,L,"강조",RED); if C < O and var1 >= var3*0.5 and var1 < var3*0.7 Then PlotPaintBar(H,L,"강조",CYAN); if C < O and var1 >= var3*0.7 and var1 < var3*0.7 Then PlotPaintBar(H,L,"강조",BLUE); ....................................................................... 50175번 문의글에서 작성해주신 수식입니다. 그런데 50% 이상은 수식표현이 되는데... 70% 이상에서는 수식 표현이 안됩니다. 살펴봐 주세요 감사합니다