Software

Ask something
Discussion Locked

Microsoft Excel won't evaluate functions

0 helpful
8 replies

by absolutely

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

in cell U1140, Excel displays

'=UPPER(B1140)'

and will not evaluate the funtion, which should be 'NAME' because the cell B1140 contains 'Name'.

8 replies

by g...

looks like excell is taking it like a string. Remove any ' or " you may have in the cell.
Eventually try writing in the field on the top of the sheet and not in the cell.

by absolutely

not the actual problem, but also not something easily available in menu or help info, so it may be useful for similar malfunctions in future.

by lord foul

Have you got Show formulas on? (ctrl+~)
OR
Have you got manual calculation on? (Tools|Options|Calculation tab)
OR
Delete the formaul and try again?

Good luck
:)

by lord foul

Have you got Show formulas on? (ctrl+~)
OR
Have you got manual calculation on? (Tools|Options|Calculation tab)
OR
Delete the formula and try again?

Good luck
:)

by absolutely

"Have you got Show formulas on? (ctrl+~)"
I tried that, and it's actually [ctrl]+[`], ~ without [shift].

"Have you got manual calculation on? (Tools|Options|Calculation tab)"

Tried that too.

"Delete the formula and try again?"

For a workaround, I won't post to TR. I'm here for a [b]solution[/b]

This discussion is closed to new replies.