Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community
SOLVED

my excel doesn't recognize dormula

Copper Contributor

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 the formula with the help of ''function arguments'' (Fx), it works, but when I write it directly in Excel, an error appears with a problem in the formula.

Has anyone ever experienced this? Can you help me please?

6 Replies

@Mygiovanana 

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

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.

@Mygiovanana 

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't
best response confirmed by Mygiovanana (Copper Contributor)
Solution

@Mygiovanana 

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.

That's right, I adjusted the ''quotes'' and it worked out great! Thank you!@Hans Vogelaar 

1 best response

Accepted Solutions
best response confirmed by Mygiovanana (Copper Contributor)
Solution

@Mygiovanana 

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.

View solution in original post