Try something similar to:

=if(JobTitle1="JT","X","")&if(JobTitle2="JT2","X", "")&if(............

--
Damon Longworth

Don't miss out on the 2005 Excel User Conference
Sept 16th and 17th
Stockyards Hotel - Ft. Worth, Texas
www.ExcelUserConference.com


"timbo" wrote in message
...
I have 3 classifications of workers(supervisors,skilled, and unskilled) and
need to post a x in a cell by their jop title. I have been using the IF
funtion for years, but only had 5 or 6 job titles. Now with more job
titles,
I have surpassed the maximum of 7 nest funtions.