View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JR Hester JR Hester is offline
external usenet poster
 
Posts: 170
Default Only first of multiple If's returns results

Excel 2007 on WinXP

I need to evaluate the contents of Column F.
If the cell contaions the word "Lead", place Lead in column G
If the cell contains the word "Manager". place Manager in column G
If the cell contains the word "Supervisor", place Super in column G

I used the formula below.
=IF(FIND("Lead", F3)0, "Lead", IF(FIND("Manager", F3)0, "manager",
IF(FIND("Supervisor", F3)0, "Super", "standard")))

Only those rows that contain "Lead: somewhere in in column F record Lead in
column G, all others report VALUE#. Can someone point me toward my error. It
is important for you to know that cells in column F wil have more than just
the word Lead, Manager or Supervisor; these words may be at beginning, in
middle or at the end. They will always be separate words.

Thanks for any suggestions