If function

[Annbc]

Hello......

I need help with below spreadsheet

12345876
17889899
18899755
88999987
66778889
77776556
How do I write an if function that states if A2 begins with 1 then B2 should be SPA if A2 begins with 8 then B2 is GBP etc.

[samba_ravi]

=if(left(a2,1)*1=1,"SPA",if(left(a2,1)*1=8,"GBP",""))
Try this

[Annbc]

Thanks it worked.