excel怎么设置的复杂公式(A1*A2+B1*B2+计算公式=D3*D4+F3*F4+H3*H4+J3*J4+K3*K4+L3*L4+N3*N4+O3*O4+Q3*Q4+R3*R4+S3*S4+T3*T4+U3*U4+V3*V4+W3*W4+X3*X4+Y3*Y4+Z3*Z4+AA3*AA4+AB3*AB4+AC3*AC4+AD3*AD4+AE3*AE4+AF3*AF4+AG3*AG4只改D4/F4/H4/J4.在下拉
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/03 00:08:39
![excel怎么设置的复杂公式(A1*A2+B1*B2+计算公式=D3*D4+F3*F4+H3*H4+J3*J4+K3*K4+L3*L4+N3*N4+O3*O4+Q3*Q4+R3*R4+S3*S4+T3*T4+U3*U4+V3*V4+W3*W4+X3*X4+Y3*Y4+Z3*Z4+AA3*AA4+AB3*AB4+AC3*AC4+AD3*AD4+AE3*AE4+AF3*AF4+AG3*AG4只改D4/F4/H4/J4.在下拉](/uploads/image/z/1066890-66-0.jpg?t=excel%E6%80%8E%E4%B9%88%E8%AE%BE%E7%BD%AE%E7%9A%84%E5%A4%8D%E6%9D%82%E5%85%AC%E5%BC%8F%EF%BC%88A1%2AA2%2BB1%2AB2%2B%E8%AE%A1%E7%AE%97%E5%85%AC%E5%BC%8F%3DD3%2AD4%2BF3%2AF4%2BH3%2AH4%2BJ3%2AJ4%2BK3%2AK4%2BL3%2AL4%2BN3%2AN4%2BO3%2AO4%2BQ3%2AQ4%2BR3%2AR4%2BS3%2AS4%2BT3%2AT4%2BU3%2AU4%2BV3%2AV4%2BW3%2AW4%2BX3%2AX4%2BY3%2AY4%2BZ3%2AZ4%2BAA3%2AAA4%2BAB3%2AAB4%2BAC3%2AAC4%2BAD3%2AAD4%2BAE3%2AAE4%2BAF3%2AAF4%2BAG3%2AAG4%E5%8F%AA%E6%94%B9D4%2FF4%2FH4%2FJ4.%E5%9C%A8%E4%B8%8B%E6%8B%89)
excel怎么设置的复杂公式(A1*A2+B1*B2+计算公式=D3*D4+F3*F4+H3*H4+J3*J4+K3*K4+L3*L4+N3*N4+O3*O4+Q3*Q4+R3*R4+S3*S4+T3*T4+U3*U4+V3*V4+W3*W4+X3*X4+Y3*Y4+Z3*Z4+AA3*AA4+AB3*AB4+AC3*AC4+AD3*AD4+AE3*AE4+AF3*AF4+AG3*AG4只改D4/F4/H4/J4.在下拉
excel怎么设置的复杂公式(A1*A2+B1*B2+计算
公式=D3*D4+F3*F4+H3*H4+J3*J4+K3*K4+L3*L4+N3*N4+O3*O4+Q3*Q4+R3*R4+S3*S4+T3*T4+U3*U4+V3*V4+W3*W4+X3*X4+Y3*Y4+Z3*Z4+AA3*AA4+AB3*AB4+AC3*AC4+AD3*AD4+AE3*AE4+AF3*AF4+AG3*AG4
只改D4/F4/H4/J4.在下拉公式显示=D3*D5+F3*F5+H3*H5+J3*J5.,继续下拉把D5/F5/H5/J5.改成=D3*D6+F3*F6+H3*H6+J3*J6.,注:D3/F3/H3/J3/K3.这些数据都不变,不要一个一个数字的改太麻烦了,有没有快捷的办法,比如说固定D3/F3等等都不动,只变其它数?
excel怎么设置的复杂公式(A1*A2+B1*B2+计算公式=D3*D4+F3*F4+H3*H4+J3*J4+K3*K4+L3*L4+N3*N4+O3*O4+Q3*Q4+R3*R4+S3*S4+T3*T4+U3*U4+V3*V4+W3*W4+X3*X4+Y3*Y4+Z3*Z4+AA3*AA4+AB3*AB4+AC3*AC4+AD3*AD4+AE3*AE4+AF3*AF4+AG3*AG4只改D4/F4/H4/J4.在下拉
=$D$3*D4+$F$3*F4+$H$3*H4+$J$3*J4+$K$3*K4+.+,总是在你不需要变的公式前加“$”就OK了
注:“$”表示绝对引用,形式有多样,比如"$A$1"、"A$1"、"$A1"、,你可以自己去慢慢体验,看那种是你需要的.