SharePoint Task List Calculated Text Field formula help 1

[jnettipaper]

Trying to get one text column to look at another text column to create the input (trying to eliminate user error).

Looking at Site column. If Site column field is "apples" or "oranges", I want Group column to say "fruit". If Site column field is "celery" or "carrots", I want Group column to say "veggie". What Am I doing wrong?

=If ([Site]="apples","fruit","")

Granted, this would not be the full formula, but I wanted to get something to work even if not the whole thing. This was just to try to temporarily make the Group column say "fruit" if Site column said "apples", blank otherwise. Getting syntax error in SharePoint.

 

[cmv131]

Make sure there are no extra spaces in your formula if you do = if ( there is an error, if you do =if( there isn't.

Try this for a longer version of your formula as well..

=IF(OR([Site] = "Apples", [Site] = "Oranges"),"Fruit", if(OR([Site] = "Celery", [Site] = "Carrots"), "Veggies","Other"))