打印本文
關閉窗口
LEVEL:=IF(CAPITAL>0 AND CAPITAL<300000,1,IF(CAPITAL>300000 AND CAPITAL<500000,2,IF(CAPITAL>500000 AND CAPITAL<1000000,3,IF(CAPITAL>1000000 AND CAPITAL<2000000,4,IF(CAPITAL>2000000 AND CAPITAL<3000000,5,IF(CAPITAL>3000000 AND CAPITAL<5000000,6,IF(CAPITAL>5000000 AND CAPITAL<10000000,7,8)))))));
TJ1:=LEVEL=1 AND DYNAINFO(9)>=150;
TJ2:=LEVEL=2 AND DYNAINFO(9)>=300;
TJ3:=LEVEL=3 AND DYNAINFO(9)>=500;
TJ4:=LEVEL=4 AND DYNAINFO(9)>=1000;
TJ5:=LEVEL=5 AND DYNAINFO(9)>=1500;
TJ6:=LEVEL=6 AND DYNAINFO(9)>=2000;
TJ7:=LEVEL=7 AND DYNAINFO(9)>=3000;
TJ8:=LEVEL=8 AND DYNAINFO(9)>=5000;
TJ1 OR TJ2 OR TJ3 OR TJ4 OR TJ5 OR TJ6 OR TJ7 OR TJ8;
參照這個公式 自己動手寫吧
LEVEL:=IF(CAPITAL>0 AND CAPITAL<300000,1,IF(CAPITAL>300000 AND CAPITAL<500000,2,IF(CAPITAL>500000 AND CAPITAL<1000000,3,IF(CAPITAL>1000000 AND CAPITAL<2000000,4,IF(CAPITAL>2000000 AND CAPITAL<3000000,5,IF(CAPITAL>3000000 AND CAPITAL<5000000,6,IF(CAPITAL>5000000 AND CAPITAL<10000000,7,8
參照這個公式 自己動手寫吧