What does ABS mean in front of a Formula

  • Thread starter Thread starter william4444
  • Start date Start date
W

william4444

Hi all,

Have a question am absolute puzzelled. The below formula has ABS after
=. The formula just caclulates a ratio thou when you do it without ABS
in front the Ratio is negative eg: -19, thou when you put ABS in front
it rides the Negative eg: 19. Why does it do this & what does ABS mean.
WOULD APPRECIATE ALL THE HELP AM AGAIN CONFUSSED I NEED A HOLIDAY.
Cheers
Will




=ABS(C36/B36)
 
from the Help file:

Returns the absolute value of a number. The absolute value of a number
is the number without its sign.
Syntax
=ABS(number)
Number is the real number of which you want the absolute value.
 
Hello:

Second one, try pushing F2 when you have these type of questions.


Pieter Vandenberg



: Hi all,

: Have a question am absolute puzzelled. The below formula has ABS after
: =. The formula just caclulates a ratio thou when you do it without ABS
: in front the Ratio is negative eg: -19, thou when you put ABS in front
: it rides the Negative eg: 19. Why does it do this & what does ABS mean.
: WOULD APPRECIATE ALL THE HELP AM AGAIN CONFUSSED I NEED A HOLIDAY.
: Cheers
: Will




: =ABS(C36/B36)


: --
: william4444
: ------------------------------------------------------------------------
: william4444's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33991
: View this thread: http://www.excelforum.com/showthread.php?threadid=537570
 
Which would put user in cell edit mode and may be of limited functionality in
this case.


Gord Dibben MS Excel MVP
 
Hello:

That's why help never comes up! I thought my Excel was broken. :)

Pieter Vandenberg

Gord Dibben <gorddibbATshawDOTca> wrote:
: Which would put user in cell edit mode and may be of limited functionality in
: this case.


: Gord Dibben MS Excel MVP

: On Sun, 30 Apr 2006 17:22:48 +0000 (UTC), vandenberg p <[email protected]>
: wrote:

:>Hello:
:>
:>Second one, try pushing F2 when you have these type of questions.
:>
:>
:>Pieter Vandenberg
:>
:>
:>
:>: Hi all,
:>
:>: Have a question am absolute puzzelled. The below formula has ABS after
:>: =. The formula just caclulates a ratio thou when you do it without ABS
:>: in front the Ratio is negative eg: -19, thou when you put ABS in front
:>: it rides the Negative eg: 19. Why does it do this & what does ABS mean.
:>: WOULD APPRECIATE ALL THE HELP AM AGAIN CONFUSSED I NEED A HOLIDAY.
:>: Cheers
:>: Will
:>
:>
:>
:>
:>: =ABS(C36/B36)
:>
:>
:>: --
:>: william4444
:>: ------------------------------------------------------------------------
:>: william4444's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=33991
:>: View this thread: http://www.excelforum.com/showthread.php?threadid=537570
 
Back
Top