if statement help!

C

cutsygurl

I need to make an if statement that looks at only part of the cell.
Example
A1 B1
487A365 =if(A1="487A", 1, 2)

so i need B1 to say 1. The last three digits dont matter, only th
first four.
If anyone can help me that would be great. :)

Thanks
Tin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top