Sharepoint - IF statements in Calculated List Column always returns "The formula contains a syntax error or is not supported"
Your formula is perfectly valid code
Language settings? Most non-english environments require a ; instead of ,
On English environments you can install a Bookmarklet to enhance the Calc editor
This blog might be of help too