Forum Discussion
patala1240
Dec 19, 2019Copper Contributor
Somme ne fonctionne pas
Pourquoi EXCEL ne calcule pas ??????
s-v-p voir p-j
Alain
1 Reply
Sort By
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