Thread: Non-signed Difference between 2 cells
View Single Post
  #2   Report Post  
arno
 
Posts: n/a
Default
Hi cherft,
rather than having to code:
=IF(A1-B1<0,(A1-B1)*-1,(A1-B1))

=abs(a1-b1)

arno
Reply With QuoteReply With Quote