ABS function

This function will return the absolute value of a number. The absolute value is the “positive” part of a number.

Syntax

ABS(Number)

  • Number (required) – This is the number you want to find the absolute value of.

Example

In this example find the absolute value of a few numbers. Text values will result in a #VALUE! error.

=ABS(A2)

ABS

About the Author

John MacDougall

John MacDougall

John is a Microsoft MVP and qualified actuary with over 15 years of experience. He has worked in a variety of industries, including insurance, ad tech, and most recently Power Platform consulting. He is a keen problem solver and has a passion for using technology to make businesses more efficient.

Subscribe

Subscribe for awesome Microsoft Excel videos 😃

👉 Find out more about our Advanced Formulas course!

Top Posts

Related Posts

Browse All

INT function

Jun 26, 2016

This function will rounds a number down to the nearest integer. Syntax...

read more

Comments

0 Comments

Get the Latest Microsoft Excel Tips

Follow Us

Follow us to stay up to date with the latest in Microsoft Excel!

Subscribe for awesome Microsoft Excel videos 😃