abs

 The ABS function in Excel is used to return the absolute value of a number, which means it converts negative numbers to positive numbers while leaving positive numbers unchanged. Below are 10 examples of how you can use the ABS function in Excel, including data and formulas.

Example 1: Basic Usage

Data:

Copy

A1: -5

Formula:

Copy

=ABS(A1)

Result:

Copy

5

Example 2: Absolute Difference Between Two Numbers

Data:

Copy

A1: 10
B1: 15

Formula:

Copy

=ABS(A1 - B1)

Result:

Copy

5

Example 3: Absolute Value in a Sum

Data:

Copy

A1: -3
A2: 4
A3: -2

Formula:

Copy

=SUM(ABS(A1), ABS(A2), ABS(A3))

Result:

Copy

9

Example 4: Absolute Value in an Average

Data:

Copy

A1: -10
A2: 20
A3: -30

Formula:

Copy

=AVERAGE(ABS(A1), ABS(A2), ABS(A3))

Result:

Copy

20

Example 5: Absolute Value in a Product

Data:

Copy

A1: -2
A2: 3
A3: -4

Formula:

Copy

=PRODUCT(ABS(A1), ABS(A2), ABS(A3))

Result:

Copy

24

Example 6: Absolute Value in a Conditional Formatting Rule

Data:

Copy

A1: -7

Formula:

Copy

=ABS(A1) > 5

Result:

Copy

TRUE

Example 7: Absolute Value in a Logical Test

Data:

Copy

A1: -8
B1: 8

Formula:

Copy

=IF(ABS(A1) = ABS(B1), "Equal", "Not Equal")

Result:

Copy

Equal

Example 8: Absolute Value in a Lookup

Data:

Copy

A1: -100
A2: 200
A3: -300

Formula:

Copy

=VLOOKUP(ABS(A1), A1:A3, 1, FALSE)

Result:

Copy

100

Example 9: Absolute Value in a Complex Formula

Data:

Copy

A1: -50
B1: 30

Formula:

Copy

=ABS(A1) + ABS(B1) / 2

Result:

Copy

65

Example 10: Absolute Value in an Array Formula

Data:

Copy

A1: -1
A2: 2
A3: -3
A4: 4

Formula:

Copy

=SUM(ABS(A1:A4))

Result:

Copy

10

These examples demonstrate various ways to use the ABS function in Excel, from simple calculations to more complex formulas involving other functions.