excel里怎样实现下拉时公式里的引用的单元格随着下拉而按列递增?A2=A1+B1,A3=A1+C1,A4=A1+D1,A5=A1+E1我的公式是A2=IF(A$1>=B$1,A$1-B$1,A$1+B$1),A3=IF(A$1>=C$1,A$1-C$1,A$1+C$1),A4=IF(A$1>=D$1,A$1-D$1,A$1+D$1),A$1不变,随着
来源:学生作业帮助网 编辑:作业帮 时间:2024/07/17 14:53:26
![excel里怎样实现下拉时公式里的引用的单元格随着下拉而按列递增?A2=A1+B1,A3=A1+C1,A4=A1+D1,A5=A1+E1我的公式是A2=IF(A$1>=B$1,A$1-B$1,A$1+B$1),A3=IF(A$1>=C$1,A$1-C$1,A$1+C$1),A4=IF(A$1>=D$1,A$1-D$1,A$1+D$1),A$1不变,随着](/uploads/image/z/1066885-61-5.jpg?t=excel%E9%87%8C%E6%80%8E%E6%A0%B7%E5%AE%9E%E7%8E%B0%E4%B8%8B%E6%8B%89%E6%97%B6%E5%85%AC%E5%BC%8F%E9%87%8C%E7%9A%84%E5%BC%95%E7%94%A8%E7%9A%84%E5%8D%95%E5%85%83%E6%A0%BC%E9%9A%8F%E7%9D%80%E4%B8%8B%E6%8B%89%E8%80%8C%E6%8C%89%E5%88%97%E9%80%92%E5%A2%9E%3FA2%3DA1%2BB1%2CA3%3DA1%2BC1%2CA4%3DA1%2BD1%2CA5%3DA1%2BE1%E6%88%91%E7%9A%84%E5%85%AC%E5%BC%8F%E6%98%AFA2%3DIF%28A%241%3E%3DB%241%2CA%241-B%241%2CA%241%2BB%241%29%2CA3%3DIF%28A%241%3E%3DC%241%2CA%241-C%241%2CA%241%2BC%241%29%2CA4%3DIF%28A%241%3E%3DD%241%2CA%241-D%241%2CA%241%2BD%241%29%2CA%241%E4%B8%8D%E5%8F%98%2C%E9%9A%8F%E7%9D%80)
x=K@ǿ
yjHTPYH1mKKCmuP+2K-tNN뵣^Pۥ2EC8ovsG?!A/sLA{N/vvZOKr=Z5E%,`Lf
`̬0m^@6^f,b3%n!,g*2 73hr^g*9G8w7Ҿu^A