Excel constructs a regular data instance 1,1.1,2,2.1,3,3.1

Source: Internet
Author: User

For example, the effect we're going to do is this:

A2 for: 1

A3 for: 1.1

A4 for: 2

A5 for: 2.1

A6 for: 3

A7 for: 3.1

......

How can data like this be constructed?

First, we analyze and find the rule: The number is an integer, the second number is the first number plus 0.1, the second number is an integer, but the integer is the previous integer plus 1, then the integer plus 0.1 ...

When we use the formula, we start using it from A3, A2 enter a 1 directly.

So, how do you use formulas when you start using formulas for padding from A3?

First, the theoretical guidance

To determine if the last number is a decimal, if so, then use the integer portion of the previous number plus 1; If the previous number does not contain decimals, then use the integer portion of the previous number plus 0.1;

Second, the realization of the formula

The complete formula in A3 is:

=if (A2-int (A2) >0,int (A2) +1,a2+0.1)

The other pull down, the regular data came out.

Here's an analysis of the formula:

=if (A2 is a small points, yes, then take A2 add 1, if not, take A2 plus 0.1)

Int (A2) to get the integer part of the A2, discard decimals;

A2-int (A2) >0,a2 subtracts the integer portion of the A2, and if >0, indicates that the A2 is a number with a decimal point.

Int (A2) +1,a2 takes an integer plus 1.

Related Keywords:
Related Article E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth \$300-1200 USD