View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default how do i calculate the difference between two numbers?

On Nov 12, 4:52 am, dig wrote:
i have two cloumns which have for example the numbers C3=2 and D3=10, where
the difference would be E3=8 and numbers C4=12 and D4=7 where the difference
would be E4=5, how do i do this in excel without getting negative numbers
such as C3-D3=-8?


=abs(C3-D3)