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
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