CELL FORMULA "EXACT"

[salvatore.quimi]

Hi all,

I’m using a write cell activity and i would write the below formula:
=OR(EXACT(Foglio3!$A$2:$A$53,Foglio2!C2))

But after run my job in my excel I have the follow formula (where “O=OR” and “IDENTICO=EXACT”) =O(IDENTICO(@Foglio3!$A$2:$A:$53; Foglio2!C3))

Any suggestion to write the correct formula?

Thanks in advanced!!!

Regards,
S.

In attached the file example:
test1.xlsx (11.9 KB)

[supermanPunch (Arpan)]

Hi @salvatore.quimi ,

It seems that the Formula being used in Excel is in the Italian Format.

O being Equivalent to OR and IDENTICO being equivalent to EXACT.

[salvatore.quimi]

Hi @supermanPunch

It’s right, but beyond the language why do I get “@” when I select the range from another sheet?

Any suggestion?

Regards

[supermanPunch (Arpan)]

@salvatore.quimi ,
Maybe you could try Changing the Language in Excel Settings.

Open Excel ->Options->Language->English->Set as Preferred->OK

Let us know if this is not a possibility.

[salvatore.quimi]

HI @supermanPunch

I have already tried changing the language settings but I have the same issue.

Another suggestion?

Thanks in advanced!!!

Regards

[supermanPunch (Arpan)]

@salvatore.quimi ,

Although I may not be entirely sure, it might be a new notation in Excel formula because of the Update.
Take a look at the below post :
https://answers.microsoft.com/en-us/msoffice/forum/all/i-would-like-to-know-the-purpose-of-the-symbol-in/fad30820-faa4-4027-beb3-0930554f627e#:~:text=The%20%40%20is%20a%20new%20notation,cells%20in%20the%20same%20row

Was your Excel/ Microsoft Office got updated recently or do you have the newest version of the Excel ?

[salvatore.quimi]

Hi @supermanPunch,

finally I change the formula into Vlookup and this it works.
“=IF(VLOOKUP(M2, A:A, 1)=M2,” +“True” +“,” +“False)”

Regards,
S.