|
fangniuji 发表于 2014-2-18 13:37
其他再帮忙一下,不胜感激,谢谢!!!
J2=TEXT(IF(OR(D2=E2,B2=C2,(B2-C2)<0),D2+SQRT(POWER(B2-C2,2)+POWER(D2-E2,2))*SIN(H2*PI()/180),IF((B2-C2)>0,D2-SQRT(POWER(B2-C2,2)+POWER(D2-E2,2))*SIN(H2*PI()/180),)),"000000")
L2=IF(B2=I2,IF(D2<J2,90,270),IF(D2=J2,IF(B2<I2,0,180),DEGREES(ATAN((J2-D2)/(I2-B2)))))
M2=TEXT(IF(OR(D2=J2,B2=I2,(B2-I2)<0),B2-K2*COS(RADIANS(L2)),IF((B2-I2)>0,B2+K2*COS(RADIANS(L2)))),"000000")
N2=TEXT(IF(OR(D2=J2,B2=I2,(B2-I2)<0),I2+K2*COS(RADIANS(L2)),IF((B2-I2)>0,I2-K2*COS(RADIANS(L2)))),"000000")
O2=TEXT(IF(OR(D2=J2,(B2-I2)>0),D2+K2*SIN(L2*PI()/180),IF(OR(B2=I2,(B2-I2)<0),D2-K2*SIN(L2*PI()/180))),"000000")
P2=TEXT(IF(OR(D2=J2,(B2-I2)>0),J2-K2*SIN(L2*PI()/180),IF(OR(B2=I2,(B2-I2)<0),J2+K2*SIN(L2*PI()/180),)),"000000") |
|