View original (French)

Calculate a positive or negative difference between two values

Solved
LEONARD1096 Posted messages 6 Status Member -  
 Philos31 -
Good evening everyone!

I am seeking your help for a recurring issue and I apologize for that.

E15= -1.0 F15= +0.4 G15= -1.4
E16= +2.0 F16= +0.2 G16= +1.8
E17= -1.7 F17= -0.4 G17= -1.3

Could a brilliant mind suggest the formula to place in G to calculate the difference between F and E?

2 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hi
    simply E15-F15, right>>?
    thx a lot

    --
    The quality of the answer mainly depends on the clarity of the question, thank you!
    0
    1. LEONARD1096 Posted messages 6 Status Member
       
      Good evening,
      Thank you for taking the time to answer this lunar question... There is surely a mistake in the way I edit my cells E and F... It seems to me that I tried with '-0.4 or -"0.4" the same goes for the positive, I imagine that's where my mistake lies?
      0
    2. Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention   17 480
       
      To perform calculations with Excel, you need to enter numeric values, not text.
      Therefore, you should not use apostrophes, quotes, or the + sign.
      You need to enter
      -1 in E15 and 0.4 in F15
      2 in E16 and 0.2 in F16
      In G15, enter the formula =E15-F15; and copy it down.
      0
      1. Philos31 > Raymond PENTIER Posted messages 58211 Registration date   Status Contributor Last intervention  
         

        It seems to me that E15-F15 will give the difference between the two values but without differentiating between positive and negative values.

        -1