Thread: abs formula
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default abs formula

The answer depends on the question. What is it that you want to calculate?

If your question is trying to ask what the ABS function does, you can find
the answer by typing ABS into Excel's help function.
--
David Biddulph

"Pammy" wrote in message
...
I have 4 columns of numbers and I am trying to get an ABS value. these are
based on years:
2005 2006 2007 2008

71 169 165 214
How do you do a ABS formula

The person who did this last year based it on 2006 and 2007 and he used:

=(C2-B2)/ABS(B2)