We have formula's like "EPMMemberProperty(,J5,"LOCKED")" to find out a locked cost center. If cost center does not exist, excel will issue error as "#Error....". If it is a French based PC, it issues error as "#Errer....". We perform certain action based on the message i.e. #Error vs #Errer. We may have other languages too in future and I do not want to code for each language.
How did you guys handled such a requirement i.e. making your formulae language independent.?