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 réponses

Réponse 1 / 2
Vaucluse Posted messages 27336 Registration date   Status Contributeur 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
julie
 
Thank you very much!!!!!!
0
Vaucluse Posted messages 27336 Registration date   Status Contributeur Last intervention   6 453
 
No problem, I'm marking the subject as resolved

safe travels

best regards
0
Mali
 
Explanation, effective and insightful, just what is needed, problem solved in 1 minute.
Thank you.
++++
0
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