Forum Discussion
sandipgumtya
Sep 16, 2020Copper Contributor
Excel formula not evaluating
I am facing a rather quirky issue with some of the excel formulae. In a few cells, the formula is not getting evaluated. It is showing the formula text instead. The formula evaluation tool shows "the cell currently being evaluated contains a constant." Any idea as to what could be the problem?
Formulas in other cells are just working fine.,
Screenshot attached.
4 Replies
Sort By
- NikolinoDEGold ContributorMaybe this file will help you, if not please just ignore it.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates) - SergeiBaklanDiamond Contributor
As variant cells with formulas are formatted as text. If so apply General format and re-enter formulas (F2, Enter)
- NikolinoDEGold ContributorWithout a file (without sensitive data) one can only guess.
My assumption is that there is an inaccessible link to another sheet in the conditional formatting.
Anyway, here is a small solution, without guarantee.
Go to Home -> Conditional Formatting -> Delete Rules -> Delete Rules in Entire Sheet.
So the message should go away.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.
- sandipgumtyaCopper Contributor