Current location - Plastic Surgery and Aesthetics Network - Plastic surgery and beauty - Excel formula of absolute value function
Excel formula of absolute value function
"excel absolute value function formula is" =ABS () ". Excel calculates the absolute value as follows:

1. Open the software and create a blank Excel, as shown below.

2. Enter the contents and data of the example in the worksheet (red box in the figure).

3. Enter "= a" in the "B2" cell to open the function list, and double-click "ABS" in it, as shown in the following figure.

4. The function formula for finding the absolute value is "ABS(number)", and select the cell "A2" (shown by the red arrow in the figure), as shown in the following figure.

5. After setting the formula, click Enter on the keyboard, as shown below.

6. The absolute value of the original data "-100" of "A2" is "100", as shown in the following figure.

7. Pull along the lower right corner of B2, and all the data in column A will be calculated according to the function formula "ABS(number)". The absolute values of all data in column A are as follows.

The function of absolute ABS, the formula is =ABS(A 1).

Let the ratio of this number to its negative number get the absolute value, and the formula is =MAX(A 1, -A 1), because any number is nothing more than a positive number, a negative number and 0.

1, the absolute value function is an even function, and its graph is symmetrical about y axis.

2. The absolute value function is differentiable only at the origin and at other points.

3. Relationship with symbolic function: ∣ x ∣ = SGN (x) x or x = SGN (x) ∣ x ∣.