IF(AND ....) get invalid message

[Nomad1]

HI,

I am trying to use and IF function with AND however when i hit enter i always get the message that the formula contains an error. Trouble is, even after investigating for a while i cant see what i am doing wrong.

I have values that currently have duplicate values for 3 columns, that being the case i want to add a value to a currently blank column.
The suggested formula that I am trying to apply is as follows-

=IF(AND(B3=B2,C3=C2,M3=M2),N2+1,1)

This would be applied in cell N3.
So when comparing rows 2 and 3, if the values for column B,C and M all match then a value in N should be created to distinguish rows 2 and 3. So if N2=1 and B,C and M all matched then N3 would be then 2.

However, i always get the error message. From the searches Ive done this syntax seems to match other searches that have been done, so I really dont know what i am doing wrong here. Any help would be appreciated.

cheers,
Nomad1

[sourabhg98]

That works for me!!
Can you post a sample workbook where you are getting this error.

[Jonmo1]

It's probably your regional settings.
Try changing the commas to semicolons ( , to ; )

[Nomad1]

I was just about to attach a sample workbook, then I read the post about commas vs semi colons.
That turned out to be the solution! I am in Norway so I presume the regional settings had something to do with it.

thanks for the replies, appreciate it.

[Jonmo1]

You're welcome.