General discussion

Locked

Microsoft Excel won't evaluate functions

By Absolutely ·
in cell U1140, Excel displays

'=UPPER(B1140)'

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

This conversation is currently closed to new comments.

8 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by G... In reply to Microsoft Excel won't eva ...

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.

Collapse -

by Absolutely In reply to

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.

Collapse -

by Lord Foul In reply to Microsoft Excel won't eva ...

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
:)

Collapse -

by Absolutely In reply to

You re-posted to correct misspelling "fomaul"?

Collapse -

by Lord Foul In reply to Microsoft Excel won't eva ...

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
:)

Collapse -

by Absolutely In reply to

"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 solution

Collapse -

by Absolutely In reply to Microsoft Excel won't eva ...

select problem cells, [alt]+F.

Thanks for nothing.

Collapse -

by Absolutely In reply to Microsoft Excel won't eva ...

This question was closed by the author

Back to Software Forum
8 total posts (Page 1 of 1)  

Related Discussions

Related Forums