+ Reply to Thread
Results 1 to 2 of 2

IF condition in Excel for many langage

  1. #1
    Forum Contributor pierre08's Avatar
    Join Date
    02-16-2010
    Location
    Paris
    MS-Off Ver
    Excel 2003
    Posts
    166

    Post IF condition in Excel for many langage

    Hi guys,
    i have a big problem with the finction if, in fact in work we've got some PCs where Excel is in English and the others where Excel is in French and one of the biggest problem is that if i use the "IF condition" in an English Excel this won't work in the french Excel and it goes the same from french to English.
    Is there a way that we could have a universal condition without changing the language of Excel.
    Thanks for your help.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Northumberland, UK
    MS-Off Ver
    O365
    Posts
    21,531

    Re: IF condition in Excel for many langage

    What you outline sounds very unusual.
    If you save the file in English and open the file on a French install Excel should automatically translate all functions and delimiters as appropriate.

    Where you may encounter issues is where you use the TEXT function for date strings etc (ie "dddd" won't translate to "jjjj" ... there was a thread on this topic not so long ago)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1