View original (French)

Formulas =L(-1)C-L(-2)C

Solved
julie -  
 Algeria -
Hello,

I don’t understand why Excel displays the formula in this way for a simple addition. Could you explain and help me to make the formulas appear in a comprehensible format?

Thank you in advance

Configuration: Windows XP / Internet Explorer 8.0

2 answers

  1.
    Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
     
    Hello
    Excel after 2007 file tab Excel 2007 Microsoft logo at the top left
    in the window at the bottom, "Excel options"
    on the left "formula"
    and look for the line "R1C1 reference style"
    unclick it and OK at the bottom

    cheers

    --
    To err is human, to persist is diabolical
    36
    1. julie
       
      Thank you very much!!!!!!
      0
    2. Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
       
      No problem, I'm marking the subject as resolved

      safe travels

      best regards
      0
    3. Mali
       
      Explanation, effective and insightful, just what is needed, problem solved in 1 minute.
      Thank you.
      ++++
      0
    4. Algeria
       

      Thank you so much ...++++++

      I accidentally fell into the same problem !!!

      And it is thanks to your guidance that I was able to get out of it and return to the classic formula.

      0