Try this:

=IF('Week 2'!$E$20="Personal","PL",IF('Week 2'!$E$20="Leave W/O
Pay","AD",LEFT('Week 2'!$E$20)))


"ppidgursky" wrote:

I am looking to add more items to a IF statement. The current is:=IF('Week
2'!$E$20="Annual","A",IF('Week 2'!$E$20="Sick","S",IF('Week
2'!$E$20="Personal","PL",IF('Week 2'!$E$20="FLSA Comp","F",IF('Week
2'!$E$20="GA Comp","G",IF('Week 2'!$E$20="Holiday","H",IF('Week
2'!$E$20="Pass","P",IF('Week 2'!$E$20="Leave W/O Pay","AD",""))))))))

I know excel says you can not use more than 7 functions in function. The
above function has 8 levels, and I need to add two more.
The current looks at a cell on 'Week2' and if the field displays "Annual"
for example, on the 2nd sheet it shows an "A". Using the same fields I want
to add 2 more; "Military Leave" to display as "M", and "Jury Duty" as "D".
I am loosing my patience on this one. Please Help.