EXCEL计算公式(加减乘除)

计算公式

选中E3输入如下公式

=((C3:C42)-$C$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((D3:D42)-$ D$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

其中*代表乘，/代表除，$c$3代表固定地址c3，ATAN代表反正切函数，

注意观察表格的范围，以检测自己所选区域的正确与否

同上…….忽略不说

=((g3:g42)-$g$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((h3:h42)-$h $3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((k3:k42)-$k$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((l3:l42)-$l$3 )*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((o3:o42)-$o$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((p3:p42)-$p $3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((s3:s42)-$s$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((t3:t42)-$t$3 )*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((w3:w42)-$w$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((x3:x42)-$ x$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((aa3:aa42)-$aa$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((ab3:ab 42)-$ab$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((ae3:ae42)-$ae$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((af3:af4 2)-$af$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((ai3:ai42)-$ai$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((aj3:aj42)-$aj$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((am3:am42)-$am$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((an3:a n42)-$an$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((aq3:aq42)-$aq$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((ar3:ar4 2)-$ar$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((au3:au42)-$au$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((av3:av4 2)-$av$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((ay3:ay42)-$ay$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((az3:az4 2)-$az$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((bc3:bc42)-$bc$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((bd3:bd 42)-$bd$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))

=((bg3:bg42)-$bg$3)*COS(ATAN(($D$42-$D$3)/($C$3-$C$42)))+((bh3:bh 42)-$bh$3)*SIN(ATAN(($D$42-$D$3)/($C$3-$C$42)))