Dec 02 2021 12:49 PM
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
Dec 02 2021 01:08 PM
Do you use comma as decimal separator? If so, use semicolon ; between arguments of a function:
=AND(J11<K11;J12<K12)
Dec 02 2021 01:23 PM
Dec 02 2021 02:17 PM
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?
Dec 02 2021 02:25 PM
Dec 02 2021 02:53 PM
In that case, the formula should work:
Does the problem persist if you quit and restart Excel? If you restart your computer?