Q&A 게시판 HOME > Q&A 게시판
작성자 : ciso 작성일 : 2023-03-19 22:03:39 조회수 : 273
항상 감사드립니다. 수식 문의드립니다.
호로로록 님의 수식 문의 글을 보고 혹시 하기 수식에서
비율값마다 영역별로 색이 다르게 표시하는 수식을 알 수 있을까요??

부탁드립니다.

input : N(150),소숫점자리(2);

var1 = Highest(H,N);
var2 = Lowest(L,N);
var : tx1(0),tx2(0),tx3(0),tx4(0),tx5(0),tx6(0);
var : tx7(0),tx8(0),tx9(0),tx10(0),tx11(0),tx12(0),tx13(0),tx14(0),tx15(0),tx(16);
plot1(var2+(var1-var2)*0.000);
plot3(var2+(var1-var2)*0.146);
plot4(var2+(var1-var2)*0.236);
plot5(var2+(var1-var2)*0.382);
plot6(var2+(var1-var2)*0.500);
plot7(var2+(var1-var2)*0.618);
plot8(var2+(var1-var2)*0.764);
plot9(var2+(var1-var2)*0.854);
plot10(var2+(var1-var2)*1.000);
plot11(var2+(var1-var2)*1.382);
plot12(var2+(var1-var2)*1.500);
plot13(var2+(var1-var2)*2.000);
plot14(var2-(var1-var2)*0.236);
plot15(var2-(var1-var2)*0.618);
plot16(var2-(var1-var2)*1.000);
plot17(var2-(var1-var2)*0.146);

Text_Delete(tx2);
Text_Delete(tx3);
Text_Delete(tx4);
Text_Delete(tx5);
Text_Delete(tx6);
Text_Delete(tx7);
Text_Delete(tx8);
Text_Delete(tx9);
Text_Delete(tx10);
Text_Delete(tx11);
Text_Delete(tx12);
Text_Delete(tx13);
Text_Delete(tx1);
Text_Delete(tx14);
tx1 = Text_New(NextBarSdate,NextBarStime,var2+(var1-var2)*0.000,"00.0%:"+NumToStr(var2+(var1-var2)*0.000,소숫점자리));
tx2 = Text_New(NextBarSdate,NextBarStime,var2+(var1-var2)*0.236,"23.6%:"+NumToStr(var2+(var1-var2)*0.236,소숫점자리));
tx3 = Text_New(NextBarSdate,NextBarStime,var2+(var1-var2)*0.382,"38.2%:"+NumToStr(var2+(var1-var2)*0.382,소숫점자리));
tx4 = Text_New(NextBarSdate,NextBarStime,var2+(var1-var2)*0.500,"50.0%:"+NumToStr(var2+(var1-var2)*0.500,소숫점자리));
tx5 = Text_New(NextBarSdate,NextBarStime,var2+(var1-var2)*0.618,"61.8%:"+NumToStr(var2+(var1-var2)*0.618,소숫점자리));
tx6 = Text_New(NextBarSdate,NextBarStime,var2+(var1-var2)*0.764,"76.0%:"+NumToStr(var2+(var1-var2)*0.764,소숫점자리));
tx7 = Text_New(NextBarSdate,NextBarStime,var2+(var1-var2)*1.000,"100.0%:"+NumToStr(var2+(var1-var2)*1.000,소숫점자리));
tx8 = Text_New(NextBarSdate,NextBarStime,var2+(var1-var2)*1.382,"138.0%:"+NumToStr(var2+(var1-var2)*1.382,소숫점자리));
tx9 = Text_New(NextBarSdate,NextBarStime,var2+(var1-var2)*1.500,"50.0%:"+NumToStr(var2+(var1-var2)*1.500,소숫점자리));
tx10 = Text_New(NextBarSdate,NextBarStime,var2+(var1-var2)*2.000,"100.0%:"+NumToStr(var2+(var1-var2)*2.000,소숫점자리));
tx11 = Text_New(NextBarSdate,NextBarStime,var2-(var1-var2)*0.236,"-23.6%:"+NumToStr(var2-(var1-var2)*0.236,소숫점자리));
tx12 = Text_New(NextBarSdate,NextBarStime,var2-(var1-var2)*0.618,"-61.8%:"+NumToStr(var2-(var1-var2)*0.618,소숫점자리));
tx13 = Text_New(NextBarSdate,NextBarStime,var2-(var1-var2)*1.000,"-100.0%:"+NumToStr(var2-(var1-var2)*1.000,소숫점자리));
tx14 = Text_New(NextBarSdate,NextBarStime,var2-(var1-var2)*0.146,"-14.6%:"+NumToStr(var2-(var1-var2)*0.146,소숫점자리)); 
목록 답변