Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am creating a tracker for my work time and I am getting fusterated at
creating this formula, any help would be apreciated: PTO=P Unpaid=U Tardy Occurrence=T Exhausted all PTO=EP Specialized PTO=SP Bereavement=B Unscheduled PTO=UP PTO Manager Override=MO Floating Holiday=MO Jury Duty=JD FMLA=FM NML=NM These are the words I am working with, I need it to work like this: if B2="UPAID" (is choosen from the list)THEN RETURN "U"in B3, IF B2="PTO", THEN RETURN "P" in B3 .....ECT... This has to work all |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
HELP with crazy formula | Excel Worksheet Functions | |||
Formula driving me crazy | Excel Discussion (Misc queries) | |||
crazy triple array formula | Excel Worksheet Functions | |||
Formula is driving me crazy????? | Excel Worksheet Functions | |||
Help I am going crazy with this formula. | Excel Worksheet Functions |