Comma (,) in logic formulas causes error!

%3CLINGO-SUB%20id%3D%22lingo-sub-3029162%22%20slang%3D%22en-US%22%3EComma%20(%2C)%20in%20logic%20formulas%20causes%20error!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3029162%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3EI%20am%20a%20new%20starter%20in%20Excel.%20I%20was%20training%20on%20custom%20commands%20in%20the%20data%20validation%20setting%20of%20a%20cell.%20I%20wrote%20the%20following%20formula%20for%20a%20sample%20cell%3A%3C%2FP%3E%3CP%3E%3DAND(J11%3CK11%3E%3C%2FK11%3E%3C%2FP%3E%3CP%3Ethe%20excel%20shows%20me%20an%20error%20comment%20that%20seems%20the%20comma%20is%20not%20valid.%20How%20it%20can%20be%3F%20it%20is%20correct%20and%20usual%3F%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3029162%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3029212%22%20slang%3D%22en-US%22%3ERe%3A%20Comma%20(%2C)%20in%20logic%20formulas%20causes%20error!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3029212%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1237252%22%20target%3D%22_blank%22%3E%40amanifard1111%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20use%20comma%20as%20decimal%20separator%3F%20If%20so%2C%20use%20semicolon%20%3B%20between%20arguments%20of%20a%20function%3A%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3DAND(J11%3CK11%3E%3C%2FK11%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi everyone,

I am a new starter in Excel. I was training on custom commands in the data validation setting of a cell. I wrote the following formula for a sample cell:

=AND(J11<K11,J12<k12)

the excel shows me an error comment that seems the comma is not valid. How it can be? it is correct and usual?

Regards

5 Replies

@amanifard1111 

Do you use comma as decimal separator? If so, use semicolon ; between arguments of a function:

 

=AND(J11<K11;J12<K12)

Thanks for your reply. I did this before, but the lfirst logic term does not work and Excel just sense the second term. Even more, when I come back to the formula I find the semicolumn has been shifted to the cell number betweein the letter and the number which make the cell address.
Regards

@amanifard1111 

Do you perhaps use R1C1 notation? If you click in the top left cell of a worksheet and look at the address box on the left hand side of the formula bar, do you see A1 or R1C1?

No this is A1. The switch of the R1C1 in options is off.

@amanifard1111 

In that case, the formula should work:

S0959.png

Does the problem persist if you quit and restart Excel? If you restart your computer?