Forum Discussion
Solved
Need help creating nested IF and LEFT formula in a calculated column
Hey! I have the following data in a text column called [Workcenter] 1 SOCS CSS SCXP SCQA SCOO SCPR I need a formula which will create the following results CC CC SCX SCQ SCO SCP...
Hi Joe
That should do the trick:
=IF(OR([Workcenter]="1 SOCS";[Workcenter]="CSS");"CC";LEFT([Workcenter];LEN([Workcenter])-1))
Depending on regional settings, replace semicolon with comma in case of issues.
Cheers
Martin
Hi Joe
That should do the trick:
=IF(OR([Workcenter]="1 SOCS";[Workcenter]="CSS");"CC";LEFT([Workcenter];LEN([Workcenter])-1))
Depending on regional settings, replace semicolon with comma in case of issues.
Cheers
Martin
Awesome! Thanks a bunch! Changed the semi-colons and it worked perfectly. Final formula looked lke this:
=IF(OR([Workcenter]="1 SOCS",[Workcenter]="CSS"),"CC",LEFT([Workcenter],LEN([Workcenter])-1))