View original (French)

Excel - formula calculation

Solved
generalbob -  
 generalbob -
Hello, I am working on Excel 2010. On one of my worksheets, it is impossible to make the formulas work. It displays the formula instead of the result.
Strangely, this problem only occurs on sheet 1 of this file, the formulas work perfectly on sheet 2.
I have looked for solutions in the Office help and online, but none work.

In my attempts, I discovered that it actually treats the formulas as constants. Indeed, when I use "evaluate formula", it responds "the cell being evaluated contains a constant".

Any ideas?

Configuration: Windows 7 / Firefox 11.0

1 answer

Answer 1 / 1
PHILOU10120 Posted messages 6463 Registration date   Status Contributor Last intervention   833
 
Hello

For Excel 2010

File
Options
Advanced Options
Display options for this worksheet
uncheck the box Formulas in cells instead of their results
Validate Ok
0
generalbob
 
No! I've tried that already. The problem is upstream; it doesn't even perform the operation. It doesn't recognize the formulas as formulas but as constants.
0
axion
 
Hello,

a suggestion;
Check that there are no "spaces" in each incriminated formula, either inside or
at the end of the formula in particular.
In this case, Excel may treat it as text and the function is inactive.

Best regards
axion
0
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
Hello
can you edit a copy of your formulas for us here?
best regards
0
generalbob
 
It's mainly sums like:

"=SUM(C71:E71)"

What bothers me the most is that sheet 2 is not affected. I typed a line of 4-5 digits in the middle of the sheet for testing, and the SUM function adds them up perfectly.
0
Vaucluse Posted messages 27336 Registration date   Status Contributor Last intervention   6 453
 
You should let us know whether or not you have the quotes that you included in your message. If you do, please remove them.
0