Use the ABS function

Support

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More...Less

The ABS function returns the absolute value of a number, that is, the distance from zero.

Example 1: Returns 10 if A1 contains the number -10:
=ABS(A1)

Example 2: Returns 0 if A1 contains the number 0:
=ABS(A1)

Example 3: Returns 10 if A1 contains the number 10:
=ABS(A1)

The ABS function returns the absolute value of a number, that is, the distance from zero.

Example 1: Returns 10 if A1 contains the number -10:
=ABS(A1)

Example 2: Returns 0 if A1 contains the number 0:
=ABS(A1)

Example 3: Returns 10 if A1 contains the number 10:
=ABS(A1)

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?