Forum Discussion

patala1240's avatar
patala1240
Copper Contributor
Dec 19, 2019

Somme ne fonctionne pas

 

 

Pourquoi EXCEL ne calcule pas ??????

s-v-p voir p-j

 

Alain

1 Reply

  • There could be a few reasons for this. These can include;

     

    • It could be the Calculation Options on the Data tab are set to Manual
    • The cell containing the SUM might be formatted as Text. Check the Number Format drop down on the Home tab.
    • Select the cell and check in the Formula Bar that a space, or an apostrophe is not accidentally entered at the beginning.
    • It could be that the Show Formulas button on the Formulas tab is switched on. So this shows the formula and not the result.

     

    Alan

Resources