ABS can be used to display the absolute value of a number. The absolute value of a number is the number without its sign.

The format for ABS is:

“number” can be a cell reference, a function or a formula that returns a number of which you want the absolute value.


Cell A1 contains -5

=ABS(A1) Result is 5
=ABS(-5) Result is 5
=ABS(5) Result is 5

ABS can also be used in VBA code:

Dim absNumber As Double
absNumber = Abs (-155.3)

variable absnumber will now contain the value 155.3

Joseph Harris

Related posts:

  1. F4 Function Key in Excel To quickly ad the $ symbol around your cell references...
  2. Excel CELL () Function The CELL function can be used to find out information...

This entry was posted on Wednesday, November 12th, 2008 at 11:28 am and is filed under Functions. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

One Response to “ABS Function, Absolute Value in Excel”

  1. peter scully on November 21st, 2011 at 2:44 pm

    peter scully…

    [...]Excel Yogi’s » Blog Archive » ABS Function, Absolute Value in Excel[...]…

Leave a Reply

You must be logged in to post a comment.