hongqi11
发表于 2016-12-3 16:18
矮油、、非常感谢楼主的分享!支持...
医知半解
发表于 2016-12-3 23:29
认真学习感谢分享
吾道问道
发表于 2016-12-3 23:38
谢谢分享,好好学习,天天向上。
海之帆
发表于 2016-12-3 23:44
特来学习学习再学习
止水一点点
发表于 2016-12-4 00:19
老师你好,我是新学员,想加速提高量学知识,特向老师请教谢谢。
国人
发表于 2016-12-4 00:36
要看隐藏内容要回复是吗?
中微子168
发表于 2016-12-4 04:01
双剑霸天地
八分贝
发表于 2016-12-4 05:51
#在这里快速回最大值:=MAX(MX0, MAX(MX1, MAX(MX2, MAX(MX3,MX4))));复#
zhuyao
发表于 2016-12-4 09:07
谢谢老师分享。
liu4110
发表于 2016-12-4 09:28
haohohohohohohohoho
阳光木子
发表于 2016-12-4 15:07
最大值:=MAX(MX0, MAX(MX1, MAX(MX2, MAX(MX3,MX4))));
禅.洛阳
发表于 2016-12-5 16:29
HB:=COST(99.3);LB:=COST(0.2);B3:=(HB-LB)/50;
B31:=HB-B3;B32:=HB-2*B3;B33:=HB-3*B3;B34:=HB-4*B3;B35:=HB-5*B3;B36:=HB-6*B3;B37:=HB-7*B3;B38:=HB-8*B3;B39:=HB-9*B3;
B310:=HB-10*B3;B311:=HB-11*B3;B312:=HB-12*B3;B313:=HB-13*B3;B314:=HB-14*B3;B315:=HB-15*B3;B316:=HB-16*B3;B317:=HB-17*B3;B318:=HB-18*B3;B319:=HB-19*B3;
B320:=HB-20*B3;B321:=HB-21*B3;B322:=HB-22*B3;B323:=HB-23*B3;B324:=HB-24*B3;B325:=HB-25*B3;B326:=HB-26*B3;B327:=HB-27*B3;B328:=HB-28*B3;B329:=HB-29*B3;
B330:=HB-30*B3;B331:=HB-31*B3;B332:=HB-32*B3;B333:=HB-33*B3;B334:=HB-34*B3;B335:=HB-35*B3;B336:=HB-36*B3;B337:=HB-37*B3;B338:=HB-38*B3;B339:=HB-39*B3;
B340:=HB-40*B3;B341:=HB-41*B3;B342:=HB-42*B3;B343:=HB-43*B3;B344:=HB-44*B3;B345:=HB-45*B3;B346:=HB-46*B3;B347:=HB-47*B3;B348:=HB-48*B3;B349:=HB-49*B3;
A1:=WINNER(HB)*100-WINNER(B31)*100;A2:=WINNER(B31)*100-WINNER(B32)*100;A3:=WINNER(B32)*100-WINNER(B33)*100;A4:=WINNER(B33)*100-WINNER(B34)*100;
A5:=WINNER(B34)*100-WINNER(B35)*100;A6:=WINNER(B35)*100-WINNER(B36)*100;A7:=WINNER(B36)*100-WINNER(B37)*100;A8:=WINNER(B37)*100-WINNER(B38)*100;
A9:=WINNER(B38)*100-WINNER(B39)*100;A10:=WINNER(B39)*100-WINNER(B310)*100;A11:=WINNER(B310)*100-WINNER(B311)*100;A12:=WINNER(B311)*100-WINNER(B312)*100;
A13:=WINNER(B312)*100-WINNER(B313)*100;A14:=WINNER(B313)*100-WINNER(B314)*100;A15:=WINNER(B314)*100-WINNER(B315)*100;A16:=WINNER(B315)*100-WINNER(B316)*100;
A17:=WINNER(B316)*100-WINNER(B317)*100;A18:=WINNER(B317)*100-WINNER(B318)*100;A19:=WINNER(B318)*100-WINNER(B319)*100;A20:=WINNER(B319)*100-WINNER(B320)*100;
A21:=WINNER(B320)*100-WINNER(B321)*100;A22:=WINNER(B321)*100-WINNER(B322)*100;A23:=WINNER(B322)*100-WINNER(B323)*100;A24:=WINNER(B323)*100-WINNER(B324)*100;
A25:=WINNER(B324)*100-WINNER(B325)*100;A26:=WINNER(B325)*100-WINNER(B326)*100;A27:=WINNER(B326)*100-WINNER(B327)*100;A28:=WINNER(B327)*100-WINNER(B328)*100;
A29:=WINNER(B328)*100-WINNER(B329)*100;A30:=WINNER(B329)*100-WINNER(B330)*100;A31:=WINNER(B330)*100-WINNER(B331)*100;A32:=WINNER(B331)*100-WINNER(B332)*100;
A33:=WINNER(B332)*100-WINNER(B333)*100;A34:=WINNER(B333)*100-WINNER(B334)*100;A35:=WINNER(B334)*100-WINNER(B335)*100;A36:=WINNER(B335)*100-WINNER(B336)*100;
A37:=WINNER(B336)*100-WINNER(B337)*100;A38:=WINNER(B337)*100-WINNER(B338)*100;A39:=WINNER(B338)*100-WINNER(B339)*100;A40:=WINNER(B339)*100-WINNER(B340)*100;
A41:=WINNER(B340)*100-WINNER(B341)*100;A42:=WINNER(B341)*100-WINNER(B342)*100;A43:=WINNER(B342)*100-WINNER(B343)*100;A44:=WINNER(B343)*100-WINNER(B344)*100;
A45:=WINNER(B344)*100-WINNER(B345)*100;A46:=WINNER(B345)*100-WINNER(B346)*100;A47:=WINNER(B346)*100-WINNER(B347)*100;A48:=WINNER(B347)*100-WINNER(B348)*100;
A49:=WINNER(B348)*100-WINNER(B349)*100;A50:=WINNER(B349)*100-WINNER(LB)*100;
MX0:=MAX(A1,MAX(A2,MAX(A3,MAX(A4,MAX(A5,MAX(A6,MAX(A7,MAX(A8,MAX(A9,A10)))))))));
MX1:=MAX(A11, MAX(A12, MAX(A13, MAX(A14, MAX(A15, MAX(A16, MAX(A17, MAX(A18, MAX(A19,A20)))))))));
MX2:=MAX(A21, MAX(A22, MAX(A23, MAX(A24, MAX(A25, MAX(A26, MAX(A27, MAX(A28, MAX(A29,A30)))))))));
MX3:=MAX(A31, MAX(A32, MAX(A33, MAX(A34, MAX(A35, MAX(A36, MAX(A37, MAX(A38, MAX(A39,A40)))))))));
MX4:=MAX(A41, MAX(A42, MAX(A43, MAX(A44, MAX(A45, MAX(A46, MAX(A47, MAX(A48, MAX(A49,A50)))))))));
最大值:=MAX(MX0, MAX(MX1, MAX(MX2, MAX(MX3,MX4))));
红土豆
发表于 2016-12-5 16:57
股份未达到或超过5%
ying_1214
发表于 2016-12-6 12:56
龙城皓人
发表于 2016-12-8 09:17
谢谢老师分享!!!!
页:
1
2
3
4
[5]
6
7
8
9
10
11
12
13
14