MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

ABS function in Excel

  Asked By: Norma    Date: Jan 19    Category: MS Office    Views: 2701

Has anyone else tried to use the ABS function?

Is there a bug in it?

When used in a formula, it was giving me incorrect results.



2 Answers Found

Answer #1    Answered By: Hisa Yoshida     Answered On: Jan 19

you will have to show us how you use it, and what incorrect
results you get on what data.

If I have the following data: Cell A1 = -4, and cell B1 = ABS(A1) = 4.

In VBA, Range("B1").value = Abs(Range("A1").value) will give you the
same result.

Worksheetfunction.abs(expression) is not a supported function. For more
information, also type in abs  in the VBE search box, look at the Abs
function search result for possible errors.

Answer #2    Answered By: Courtney Hughes     Answered On: Jan 19

It works OK for me. Show us the formula  and the input and we might be able to

You were expecting it to do:

If input > 0 result = input
If input = 0 result = 0
If input < 0 result = -input ?

Didn't find what you were looking for? Find more on ABS function in Excel Or get search suggestion and latest updates.