Thread: Absolute Value
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default 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