What does ABS mean in front of a Formula

[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)

 

[Hugh]

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.

 

[Bernard Liengme]

For future problems like this, may I (with great respect) suggest you have a
look in Excel's Help facility?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"william4444" <[email protected]>
wrote in message
news:[email protected]...

 

[vandenberg p]

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