View original (French)

How to make negative numbers positive

zara70 Posted messages 188 Status Member -  
eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   -
Hello,

Can you tell me how to make negative numbers positive?

I tried using "cell format"; I can change the display but Excel still keeps the number as negative, which I do not want. I want Excel to consider it a positive number in calculations.

Is this possible?

Thanks again

Zara70

1 answer

  1.
    Gyrus Posted messages 3360 Status Member 526
     
    Hello,

    You can use the ABS function which returns the absolute value of a number.
    (the absolute value of a number is the number without its sign).

    See you!
    1
    1. zara70 Posted messages 188 Status Member 1
       
      Hello,

      How to use the ABS function knowing that I am already in a cell that contains a formula?

      Thank you

      Zara70
      0
    2. eriiic Posted messages 24581 Registration date   Status Contributor Last intervention   7 281
       
      Hello,

      =ABS(your_formula)
      eric
      3