本帖最后由 1091126096 于 2011-10-20 15:26 编辑
字符数 公式
21 =B1*DAY(DATE(,A1,33))
23 =B1*DAY(DATE(16,A1,33))
25 =(33-DAY(EDATE(0,A1)))*B1
26 =(33-DAY(DATE(,A1+1,)))*B1
26 =B1*MID(242323223232,A1,1)
26 =3-MOD(A1+(A1>7),2)+(A1=2)
27 =(33-DAY(DATE(4,A1+1,)))*B1
28 =(33-DAY(DATE(12,A1+1,)))*B1
28 =B1*MIN(DAY((A1&"-1")+32),4)
29 =MOD(33,DAY(DATE(,A1+1,)))*B1
30 =B1*(33-DAY(EOMONTH(1431,A1)))
38 =(33-DAY(EOMONTH("12-"&A1&"-1",0)))*B1
39 =TEXT(DAY(DATE(,A1+1,))-30,"2;4;3;")*B1
42 =IF(A1=2,4,MOD(MOD(A1,2)+(A1>7)+1,2)+2)*B1
43 =B1*IF(A1=2,4,IF(DAY(DATE(,A1+1,))>30,2,3))
49 =IF(A1=2,B1*4,IF((A1<7.5)+MOD(A1,2)=1,B1*3,B1*2))
50 =LOOKUP(A1,ROW(1:12),B1*{2,4,2,3,2,3,2,2,3,2,3,2})
53 =IF(A1=2,B1*4,IF(OR(A1=4,A1=6,A1=9,A1=11),B1*3,B1*2))
53 =IF(A1=2,B1*4,IF(OR(A1=4,A1=6,A1=9,A1=11),B1*3,B1*2))
71 =IF(TYPE(MATCH(A1,{4,6,9,11},))=1,B1*3,IF(A1=2,B1*4,IF(A1>12,"",B1*2)))
46字符: =IF(OR(A1={4,6,9,11}),B1*3,IF(A1=2,B1*4,B1*2)) |