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.
RegardsDo 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.
