Absolute Value
 

How do you create a function to yield an absolute value of a cell in another
cell. For example, A1= -23. I want the absolute value 23 to be deplayed in
B12. But, if the A1 value is 23 instead, still the absolute value in B12
would still be 23.

hope this makes sense.

Thx
eric

Absolute Value
 

no need to create. look in the help index for ABS

--
Don Guillett
SalesAid Software

"EG" wrote in message
...
How do you create a function to yield an absolute value of a cell in
another
cell. For example, A1= -23. I want the absolute value 23 to be deplayed
in
B12. But, if the A1 value is 23 instead, still the absolute value in B12
would still be 23.

hope this makes sense.

Thx
eric

Absolute Value
 

hi Eg.

=abs(a1)

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"EG" escreveu:

How do you create a function to yield an absolute value of a cell in another
cell. For example, A1= -23. I want the absolute value 23 to be deplayed in
B12. But, if the A1 value is 23 instead, still the absolute value in B12
would still be 23.

hope this makes sense.

Thx
eric