递增所有数字

本文介绍了递增所有数字的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

假设我有一个以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.