View original (French)

Excel absolute difference between 2 values

Pascal -  
Hello,
In an Excel spreadsheet, I'm looking for the formula that calculates the difference between 2 values, the result should be in absolute value (without a positive or negative sign).
Thank you very much for your help.
Configuration: Windows XP Internet Explorer 6.0

1 answer

  1.  gbinforme Contributor
    Hello

    With your data in A1 and B1, this should solve your issue 
    =IF(A1>B1;A1-B1;(A1-B1)*-1)

    --

    Always zen
    1. Pascal
      Thank you very much.
    2. LexMarc
      Hello

      Why not use the Absolute function = ABS(A1-B1)
      More economical in terms of memory used

      @+ LM
    4. guyguy
      Thank you for keeping me informed.