Results 1 to 4 of 4

vba to get the absolute value

This is a discussion on vba to get the absolute value within the Excel Questions forums, part of the Question Forums category; Hi, I can't seem to find this anywhere & there's no "worksheetfunction.abs" to use. Thanks for your help!...

  1. #1
    Board Regular
    Join Date
    Aug 2003
    Posts
    98

    Default vba to get the absolute value

    Hi, I can't seem to find this anywhere & there's no "worksheetfunction.abs" to use. Thanks for your help!

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Phoenix, Arizona
    Posts
    1,711

    Default Re: vba to get the absolute value

    how about a formual that takes the max of X or -X

  3. #3
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330

    Default Re: vba to get the absolute value

    Abs(number)

    Regards,
    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  4. #4
    Board Regular
    Join Date
    Aug 2003
    Posts
    98

    Default Re: vba to get the absolute value

    Thanks, I just realized that "abs()" is all I needed

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com