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
excel
Alan_Murray's avatar
Alan_Murray
MVP
Dec 20, 2019

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