6 lı kurguyu 4 lü kurguya çevirmek

Question

Al If(MOV(C,opt1,VAR)>OTT(C,opt1,7), If(MOV(C,opt1,VAR)>OTT(C,opt1,3.5), MOV(C,Opt1,VAR)>OTT(C,Opt1,Opt2)*(1+Opt3) AND STOSK(Opt4,Opt5,111,VAR)+1000>OTT(STOSK(Opt4,Opt5,111,VAR)+1000,2,Opt6) AND H>REF(HHV(H,20),-1), MOV(C,Opt1,VAR)>OTT(C,Opt1,Opt2)*(1+Opt3) AND STOSK(Opt4,Opt5,111,VAR)+1000>OTT(STOSK(Opt4,Opt5,111,VAR)+1000,2,Opt6) AND H>REF(HHV(H,20),-1)) AND H>REF(H,-1), MOV(C,opt1,VAR)>OTT(C,opt1,3.5) AND MOV(C,Opt1,VAR)>OTT(C,Opt1,Opt2)*(1+Opt3) AND STOSK(Opt4,Opt5,111,VAR)+1000>OTT(STOSK(Opt4,Opt5,111,VAR)+1000,2,Opt6) AND H>REF(HHV(H,20),-1)) AND H>REF(H,-1) AND ((HOUR()=10 AND MINUTE()>=03) OR HOUR()>=11) AND ((HOUR()=17 AND MINUTE()OTT(C,40,3.5), MOV(C,Opt1,VAR)

Answer 1

merhaba,

öncelikle formülünüzde hata var gönderdiğiniz şekliyle çalışmaz,

aşağıdaki gibi bir formülü sadeleştirmek istiyorsunuz galiba

If(MOV(C,opt1,VAR)>OTT(C,opt1,7),

If(MOV(C,opt1,VAR)>OTT(C,opt1,3.5),

MOV(C,Opt1,VAR)>OTT(C,Opt1,Opt2)*(1+Opt3) AND

STOSK(Opt4,Opt5,111,VAR)+1000>OTT(STOSK(Opt4,Opt5,111,VAR)+1000,2,Opt6) AND

H>REF(HHV(H,20),-1),

MOV(C,Opt1,VAR)>OTT(C,Opt1,Opt2)*(1+Opt3) AND

STOSK(Opt4,Opt5,111,VAR)+1000>OTT(STOSK(Opt4,Opt5,111,VAR)+1000,2,Opt6) AND

H>REF(HHV(H,20),-1)) AND H>REF(H,-1),

MOV(C,opt1,VAR)>OTT(C,opt1,3.5) AND

MOV(C,Opt1,VAR)>OTT(C,Opt1,Opt2)*(1+Opt3) AND

STOSK(Opt4,Opt5,111,VAR)+1000>OTT(STOSK(Opt4,Opt5,111,VAR)+1000,2,Opt6) AND

H>REF(HHV(H,20),-1)) AND H>REF(H,-1) AND

((HOUR()=9 AND MINUTE()>=36) OR HOUR()>=11) AND ((HOUR()=17 AND MINUTE()<=58) OR HOUR()<=16)

 

buna istinaden aşağıdaki formülü inceleyiniz

If(MOV(C,opt1,VAR)>OTT(C,opt1,7),
If(MOV(C,opt1,VAR)>OTT(C,opt1,3.5),

MOV(C,Opt1,VAR)>OTT(C,Opt1,Opt2)*(1+Opt3) AND
STOSK(Opt4,Opt5,111,VAR)+1000>OTT(STOSK(Opt4,Opt5,111,VAR)+1000,2,Opt6) AND
H>REF(HHV(H,20),-1),

MOV(C,Opt1,VAR)>OTT(C,Opt1,Opt2)*(1+Opt3) AND
STOSK(Opt4,Opt5,111,VAR)+1000>OTT(STOSK(Opt4,Opt5,111,VAR)+1000,2,Opt6) AND
H>REF(HHV(H,20),-1)) AND H>REF(H,-1),0) AND H>REF(H,-1) AND

((HOUR()=9 AND MINUTE()>=36) OR HOUR()>=11) AND ((HOUR()=17 AND MINUTE()<=58) OR HOUR()<=16)

 

bilgilerinize

not(isteğinizi karşılamıyorsa egitim@matriksdata.com mail atınız daha detaylı şekilde )