inserting text in front and behind a value

[lefty38]

what formula would i use to achieve the results in column B2:B6

not sure how to incorporate the "==" or the extra ")" "{"

if (ID == 'A2') {'SPC'} else

excel 2003 is what it is needed for

Excel 2007<table rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6" cellpadding="2.5px"><colgroup><col style="background-color: #E0E0F0" width="25px"><col><col></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th>
</th><th>A</th><th>B</th></tr></thead><tbody><tr><td style="color: #161120;text-align: center;">1</td><td style=";">ID</td><td style=";">Code Desired Output
</td></tr><tr><td style="color: #161120;text-align: center;">2</td><td style=";">1940</td><td style=";">if (ID == '1940') {'SPC'} else</td></tr><tr><td style="color: #161120;text-align: center;">3</td><td style=";">6652</td><td style=";">if (ID == '6652') {'SPC'} else</td></tr><tr><td style="color: #161120;text-align: center;">4</td><td style=";">53228</td><td style=";">if (ID == '53228') {'SPC'} else</td></tr><tr><td style="color: #161120;text-align: center;">5</td><td style=";">83839</td><td style=";">if (ID == '53839') {'SPC'} else</td></tr><tr><td style="color: #161120;text-align: center;">6</td><td style=";">63442</td><td style=";">if (ID == '63442') {'SPC'} else</td></tr><tr><td style="color: #161120;text-align: center;">7</td><td style=";">176768</td><td style=";">if (ID == '176768') {'SPC'} else</td></tr><tr><td style="color: #161120;text-align: center;">8</td><td style=";">2295028</td><td style=";">if (ID == '2295028') {'SPC'} else</td></tr></tbody></table>

Sheet1​

As always thank you

 

[CWatts]

="if (ID == '"&A2&"') {'SPC'} else"