No matter how simple I make my formula I always get an error when I try to save a new calculated column with an IF statement in it. For example:
=IF("Foobar"="Foobar", "Foo", "Bar")
On save I get "The formula contains a syntax error or is not supported"
BTW. I'm using Sharepoint in Office 365