Thread
:
Absolute Value
View Single Post
#
2
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
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
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett