Need help creating nested IF and LEFT formula in a calculated column

Question

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

I'm trying to combine these 2 working formulas

=IF([Workcenter]="1 SOCS","CC",IF([Workcenter]="CSS","CC"))

=LEFT([Workcenter],LEN([Workcenter])-1)

I tried this formula without success

=IF(Workcenter="1 SOCS","CC",IF(Workcenter="CSS","CC"(=LEFT([Workcenter],LEN([Workcenter])-1))))

Any ideas?

Answer 1

Equals ("=") just means a formula follows. You one need one per formula. Try removing the extra equal sign in front of the LEFT.

=IF(Workcenter="1 SOCS","CC",IF(Workcenter="CSS","CC", (LEFT([Workcenter],LEN([Workcenter])-1))))

A more neatly formatted version:

=IF(
    Workcenter="1 SOCS","CC",
    IF(
       Workcenter="CSS","CC",
       LEFT([Workcenter],LEN([Workcenter])-1)
    )
 )

Answer 2

Thanks for the help Mike! This is what I have working:

=IF(OR([Workcenter]="1 SOCS",[Workcenter]="CSS"),"CC",LEFT([Workcenter],LEN([Workcenter])-1))