Sunday, April 20, 2014

yogi_Compute Row By Row The Zodiac Sign Based On Person's BirthDay (actually just month and day)


                                         Google Spreadsheet   Post  #1608
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Apr-21-2014
post by Gillermo: (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/eTn-lMBa09w)
Formula to determine the Zodiac sign?
Hi, I am trying to convert a date to the corresponding zodiac sign. But I can't get it to work.

The most sophisticated solution I've found is:
=LOOKUP(TEXT(B2;"md");{101;121;220;321;421;521;621;724;824;924;1024;1123;1222:"Capricorn";"Aquarius";"Pisces";"Aries";"Taurus";"Gemini";"Cancer";"Leo";"Virgo";"Libra";"Scorpio";"Sagittarius";"Capricorn"})

Source: http://www.mrexcel.com/forum/excel-questions/55815-formula-determine-zodiac-sign-3.html#post3641897

I am quite new to Google Sheet formulas and not really sure how to decipher the formula above. But I've validated some parts of it, and TEXT(B2;"md") works with my numbers and date format. To make it more complex, it seems like my language (Swedish) is forcing Google Docs to use semicolon instead of comma.
What is the stuff between the curly brackets? An array or a vector?

-----------------------------------------------------------------------------------------------------------------------------------------



No comments:

Post a Comment