The year of the rat

[solbjerg]

Hi All
If anyone should be interested in knowing which Chinese animal sign they are born under, they can use the following function string in Excel or in Open Office calculator to find out.
Write the year of your birth in A1, insert the appropriate string in B1 and click on the green checkmark to the left. Your sign will then be shown in B1.
If it does not work in your language try to exchange the commaes with semicolon or vice versa.
I would be interested in seeing what separator is used in the different countries, and also in seeing the string in your native language.
Thanks!

Here Danish with the signs in Chinese

=Vælg(Rest(A1+8;12)+1;" 鼠";"牛";"虎";"兔";"龍";"蛇";"馬";"羊";"猴";"雞";"狗";"豬")& "年"

Here Danish with the signs in Danish

=VÆLG(REST(A1+8;12)+1;"Rottens";"Oksens";"Tigerens";"Harens";"Dragens";"Slangens";"Hestens";"Gedens";"Abens";"Hanens";"Hundens";"Grisens")&" år"

Here English with the signs in English

=Choose(Mod(A1+8,12)+1,"Rat","Ox","Tiger","Rabbit","Dragon","Snake","Horse","Goat","Monkey","Rooster","Dog","Pig")&" year"

Here in English with the signs in Chinese

=Choose(Mod(A1+8,12)+1," 鼠","牛","虎","兔","龍","蛇","馬","羊","猴","雞","狗","豬")& " 年"

Cheers
solbjerg