If Statement
I see that. Thank you. Please forgive my stuburness, you have been extremely
helpful. Does the LEFT automatically use the rest of the list?
"Teethless mama" wrote:
It's "magic" formula
"ppidgursky" wrote:
Well i'll be....I have been humbled.....
Now can you explain how that worked for the entire list, when only a few
were listed in the argument.
"Teethless mama" wrote:
No, No, No
Just copy exact the formula I provided to you. It should work
"ppidgursky" wrote:
This is what I wrote, and still received the error. Where am I going wrong?
=IF('Week 1'!$E$21="Annual","A",IF('Week 1'!$E$21="Sick","S",IF('Week
1'!$E$21="Personal","PL",IF('Week 1'!$E$21="FLSA Comp","F",IF('Week
1'!$E$21="GA Comp","G",IF('Week 1'!$E$21="Holiday","H",IF('Week
1'!$E$21="Pass","P",IF('Week 1'!$E$21="Leave W/O Pay","AD",IF('Week
1'!$E$21="Military","M",IF('Week 1'!$E$21="Jury
Duty","J",LEFT('Week1'!$E$21)))))))))))
"Teethless mama" wrote:
Try my formula it will work exactly what you want
"ppidgursky" wrote:
I tried that, and that worked with the original 8 items, but I need to add 2
more to the list, and excel will not allow it. That hole cant add more than 7
funtions in a function thing. Looking at alternative methods, and the look up
works but I can't leave a blank. I am trying to mix the 2 together, if and
vlookup, and it works, but also will not give a blank, just a #N/A
"Teethless mama" wrote:
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.
|