View original (French)

Automatic formula calculation

Solved
Chris-des-Joncs Posted messages 73 Registration date   Status Member Last intervention   -  
Chris-des-Joncs Posted messages 73 Registration date   Status Member Last intervention   -
Hello, when I enter formulas in a cell, some parts calculate and the formula disappears. How can I make the final value appear when displaying the cell, but still be able to access the underlying calculations by showing the cell's content? Thank you in advance for your help.

1 answer

  1.
    Yoyo01000 Posted messages 1720 Registration date   Status Member Last intervention   168
     
    Hello,

    You will need to share your file or at least give us the formula or formulas used because personally, I don't quite understand your problems and expectations!

    To share an anonymized file:

    https://www.cjoint.com/
    OR
    https://mon-partage.fr/

    --
    Please remember to use "thank you" and "resolved" when the issue is settled.
    1
    1. Chris-des-Joncs Posted messages 73 Registration date   Status Member Last intervention   3
       
      Hello, Thank you for the quick response. Thanks to your request for clarification, I just understood: when I type "+" at the beginning of a formula, Excel calculates certain parts of the formula, but if I type "=", I retain the encoded values. Thank you and have a nice day!
      0