递增所有数字 [英] Increment all numbers

问题描述

假设我有一个以32、33、33.1、34开头的数字列表，依此类推.因此，我要实现的目标是，如果我将数字32替换为42，则所有其他数字也应更改为42,43,43.1,44.有没有任何方法可以使用任何编辑器或逻辑来实现此目的，或者可以在excel工作表中找到.

Suppose I have a list of numbers starting with 32,33,33.1,34 and so on. So what i am trying to achieve is , if I will replace the number 32 to 42 then all other numbers should also change like 42,43,43.1,44. Is there any way to achieve this using any editor or logic or may be in excel sheet.

推荐答案

在Excel中.将数字32放入单元格A1中.然后在A2中输入'= A1 + 1'.在A2中输入'= A1 + 1.1'等.然后，当您将32更改为42时，所有其他单元格将自动更新.

In Excel. Put the number 32 in cell A1. Then in A2, put '=A1+1'. In A2 put '=A1+1.1' etc. Then when you change 32 to 42, all the other cells will be updated automatically.

这篇关于递增所有数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！