search cell for certain value

C

cparsons

I got this to work but it is only looking at the first position.
still need something that will check the entire cell.

=IF(LEFT(A1,1)="%","Contractor","")

Thanks
 
M

mzehr

Hi,
I'm not sure if this is the most efficient, but try:
=IF(ISERROR(FIND("%",A1)),"","Contractor")
 
Top