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 ...
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?