Can someone make me a formula to display the following. I have a column of numbers in row a so a1=7500300 and I want column be to have a function to tell that it is FA - Indirect. Is there any if statement that can handle the following requirements?
75XX3xxx = FA - Indirect
75XX7xxx = FA - R&D
75XX4xxx = FA - Sales & Marketing
75XX5xxx = FA - Sales & Marketing
75XX6xxx = FA - Admin
7XXX = FA - DGP
75XX3xxx = FA - Indirect
75XX7xxx = FA - R&D
75XX4xxx = FA - Sales & Marketing
75XX5xxx = FA - Sales & Marketing
75XX6xxx = FA - Admin
7XXX = FA - DGP