Forum Discussion
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...
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
Regards