[EXCEL] IF function

[mrwa92100]

Dear all,

I've been trying to create a IF function, followed the tutorial on microsoft website but still I can't make it work. 

Here's the function I tried : =SI(ESTNUM(CHERCHE(ZONE_WE_FR; C2)); "France"; Other")

I tried with space, no space, with [ and without and I get the same result.

Thank you for your help. 

Regards

[#2]

@mrwa92100 

You have to enclose literal text values in quotes:

=SI(ESTNUM(CHERCHE("ZONE_WE_FR"; C2)); "France"; Other")

[#3]

Thank you for your answer but even when I do this it still doesn't work.

[#4]

@mrwa92100 

Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?