各位大神,VB里面求和SUM公式里可以有IF条件吗?
各位大神,VB里面求和SUM公式里可以有IF条件吗?
比如,我是从Excel中拷出来的公式
=IF(MOD(A8,4)=0,SUM(IF(SIN(A12)>0,((B5/2+D5)*SIN(A12))^2*2,0),IF(AND(A8/2>2,SIN(2*A12)>0),((B5/2+D5)*SIN(2*A12))^2*2,0),IF(AND(A8/2>3,SIN(3*A12)>0),((B5/2+D5)*SIN(3*A12))^2*2,0),IF(AND(A8/2>4,SIN(4*A12)>0),((B5/2+D5)*SIN(4*A12))^2*2,0),IF(AND(A8/2>5,SIN(5*A12)>0),((B5/2+D5)*SIN(5*A12))^2*2,0),IF(AND(A8/2>6,SIN(6*A12)>0),((B5/2+D5)*SIN(6*A12))^2*2,0),IF(AND(A8/2>7,SIN(7*A12)>0),((B5/2+D5)*SIN(7*A12))^2*2,0),IF(AND(A8/2>8,SIN(8*A12)>0),((B5/2+D5)*SIN(8*A12))^2*2,0),IF(AND(A8/2>9,SIN(9*A12)>0),((B5/2+D5)*SIN(9*A12))^2*2,0),IF(AND(A8/2>10,SIN(10*A12)>0),((B5/2+D5)*SIN(10*A12))^2*2,0),IF(AND(A8/2>11,SIN(11*A12)>0),((B5/2+D5)*SIN(11*A12))^2*2,0),IF(AND(A8/2>12,SIN(12*A12)>0),((B5/2+D5)*SIN(12*A12))^2*2,0),IF(AND(A8/2>13,SIN(13*A12)>0),((B5/2+D5)*SIN(13*A12))^2*2,0),IF(AND(A8/2>14,SIN(14*A12)>0),((B5/2+D5)*SIN(14*A12))^2*2,0),IF(AND(A8/2>15,SIN(15*A12)>0),((B5/2+D5)*SIN(15*A12))^2*2,0),IF(AND(A8/2>16,SIN(16*A12)>0),((B5/2+D5)*SIN(16*A12))^2*2,0),IF(AND(A8/2>17,SIN(17*A12)>0),((B5/2+D5)*SIN(17*A12))^2*2,0),IF(AND(A8/2>18,SIN(18*A12)>0),((B5/2+D5)*SIN(18*A12))^2*2,0),IF(AND(A8/2>19,SIN(19*A12)>0),((B5/2+D5)*SIN(19*A12))^2*2,0),IF(AND(A8/2>20,SIN(20*A12)>0),((B5/2+D5)*SIN(20*A12))^2*2,0))
这个可以在VB中实现吗?