Forum Discussion
my excel doesn't recognize dormula
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.
This problem can happen if you use the wrong argument separator.
If you use point as decimal separator (two-and-a-half is written as 2.5), then you need to use comma as argument separator. Examples:
=SUM(A1, B2)
=IF(A1>0, "Positive", "Not positive")
If you use comma as decimal separator (two-and-a-half is written as 2,5), then you need to use semicolon as argument separator. Examples:
=SUM(A1; B2)
=IF(A1>0; "Positive"; "Not positive")
What is the formula that was rejected?
And what does it look like when you create it using the fx button?
- I 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'tMake 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.