Forum Discussion
Mygiovanana
Jan 08, 2024Copper Contributor
my excel doesn't recognize dormula
Hello, I would like to ask for help since my Excel does not recognize the formula when I type it into the cell. I don't know why, maybe it's some configuration but I can't adjust it. When I type th...
- Jan 08, 2024
Make sure that you use straight quotes " around text strings, not curly quotes “. Excel doesn't recognize the latter. Also, the double quote " is a single character, not two single quotes in a row.
Mygiovanana
Jan 08, 2024Copper Contributor
thanks for the help but i tried both ways and it still won't, with the help of excel that assembles the formula for me it recognizes the '';'', but when I do the part it doesn't recognize it with a formula and asks to put a '''*'' in front.
HansVogelaar
Jan 08, 2024MVP
What is the formula that was rejected?
And what does it look like when you create it using the fx button?
- MygiovananaJan 08, 2024Copper ContributorI tried using the ''if'' formula.
When I use fx it brings me up like this: =IF(A1>0;" Positive";" Not positive").
I try to replicate it the same way but I can't- HansVogelaarJan 08, 2024MVP
Make sure that you use straight quotes " around text strings, not curly quotes “. Excel doesn't recognize the latter. Also, the double quote " is a single character, not two single quotes in a row.
- MygiovananaJan 09, 2024Copper Contributor
That's right, I adjusted the ''quotes'' and it worked out great! Thank you!HansVogelaar