Forum Discussion
[EXCEL] IF function
Dear all,
I've been trying to create a IF function, followed the tutorial on https://support.microsoft.com/en-us/office/if-function-69aed7c9-4e8a-4755-a9bc-aa8bbff73be2 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
3 Replies
You have to enclose literal text values in quotes:
=SI(ESTNUM(CHERCHE("ZONE_WE_FR"; C2)); "France"; Other")
- Thank you for your answer but even when I do this it still doesn't work.
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?
