New 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 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

# Re: Comma (,) in logic formulas causes error!

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

=AND(J11<K11;J12<K12)

# Re: Comma (,) in logic formulas causes error!

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

# Re: Comma (,) in logic formulas causes error!

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?

# Re: Comma (,) in logic formulas causes error!

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

# Re: Comma (,) in logic formulas causes error!

In that case, the formula should work:

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