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