|
If Statement
I have looked at it but that is new territory for me. Any suggestions?
"Don Guillett" wrote: Have a look in the help index for VLOOKUP -- Don Guillett Microsoft MVP Excel SalesAid Software "ppidgursky" wrote in message ... 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. |
If Statement
Basically, you build up a table somewhere on your worksheet, e.g. in X1:Y10
and you just list the choices like this: Annual A Sick S Personal PL FLSA Comp F GA Comp G Holiday H Pass P Leave W/O Pay AD Then you would have one formula along the lines of: =VLOOKUP('Week 2'!E20,X$1:Y$10,2,0) and that will return the appropriate letter code. Hope this helps. Pete "ppidgursky" wrote in message ... I have looked at it but that is new territory for me. Any suggestions? "Don Guillett" wrote: Have a look in the help index for VLOOKUP -- Don Guillett Microsoft MVP Excel SalesAid Software "ppidgursky" wrote in message ... 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. |
If Statement
That worked perfectly. But one other thing. If field 'Week 2'!E20 is blank,
can I get it to produce a blank. I tried your example and used X1 and Y1 as blanks, but it did not work. I guess I could type something there and change the font color, but that is a cheap work around. Trying to get this right. "Pete_UK" wrote: Basically, you build up a table somewhere on your worksheet, e.g. in X1:Y10 and you just list the choices like this: Annual A Sick S Personal PL FLSA Comp F GA Comp G Holiday H Pass P Leave W/O Pay AD Then you would have one formula along the lines of: =VLOOKUP('Week 2'!E20,X$1:Y$10,2,0) and that will return the appropriate letter code. Hope this helps. Pete "ppidgursky" wrote in message ... I have looked at it but that is new territory for me. Any suggestions? "Don Guillett" wrote: Have a look in the help index for VLOOKUP -- Don Guillett Microsoft MVP Excel SalesAid Software "ppidgursky" wrote in message ... 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. |
| All times are GMT +1. The time now is 01:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com