Excel ABS function

  • Post author:
  • Post category:Blog
  • Post comments:0 Comments
You are currently viewing Excel ABS function

Here, we will learn how to use the Excel math function: ABS.

ABS function

The Excel ABS function converts negative numbers to positive numbers, and positive numbers are unaffected. The function can be found in all the versions of Excel. ABS takes just a required argument number, which must be a numeric value.

The formula in B3, copied down, is:

=ABS(A3)

You have successfully learnt how to use the Excel math function: ABS.

Download Practice Workbook

Kunal

Hey, I am Kunal Aggarwal, the founder and author of Kunal Excel Tip based in New Delhi, India. I have completed my postgraduation from NIIT Limited, New Delhi in Excel course in 2019. Since then, I have been using and learning Microsoft Excel and started writing posts on the spreadsheet software here since March 2024.

Leave a Reply