Forum Discussion
amanifard1111
Dec 02, 2021Copper Contributor
Comma (,) in logic formulas causes error!
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 exc...
amanifard1111
Dec 02, 2021Copper Contributor
No this is A1. The switch of the R1C1 in options is off.
HansVogelaar
Dec 02, 2021MVP
In that case, the formula should work:
Does the problem persist if you quit and restart Excel? If you restart your computer?