Current Position:Home > IF statement in calculated SharePoint 2010column

IF statement in calculated SharePoint 2010column

Update:10-11Source: network consolidation
Advertisement
Can someone look at this syntax for a calculated SharePoint column. I am getting a syntax error - SharePoint 2010.
=IF([RESP]=””,”Black”,IF([RESP]=”C1″,”Red”,IF([RESP]=”G1″,”Gold”,IF([RESP]=”A6″,”Green”,IF([RESP]=”E7″,”DarkBlue”,IF([RESP]=”A5″,”DarkCyan”,IF([RESP]=”L9″,”DarkRed”,IF([RESP]=”L6″,”Gray”,””))))))))
Thanks
Chad

The Best Answer

Advertisement
AnotherSharePointRookie,
As per your description
I have created a list in my environment
Crate 2 column as per your formula
use below formula
=IF(RESP="","Black",IF(RESP="C1","Red",IF(RESP="G1","Gold",IF(RESP="A6","Green",IF(RESP="E7","DarkBlue",IF(RESP="A5","DarkCyan",IF(RESP="L9","DarkRed",IF(RESP="L6","Gray",""))))))))
It worked as per expectation
Please 'propose as answer' if it helped you, also 'vote helpful' if you like this reply.