Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Good evening.
I am having a problem with my IF, AND, OR formula. I believe is may be in my formula itself. Status can be: FT or PT or CN; IF FT =1 they receive 5 days family leave. IF FT <1 they rec 3 days. IF PT 2 they rec 3 days. all else 0. my formula is: =IF(OR(B6="FT",B6="PT"),IF(AND(C6=5,C6<1,5,3),IF( C62,3,0)),"") Name Status Yrs Employed Vacation Leave Used Vacation Leave Remaining Vacation Leave Family Leave Used Family Leave Remaning Family Leave Abba FT 0.1 7 5 2 FALSE 0 -- I would appreciate any ideas or comments to assit me in locating the correct formula. This AND/OR has me baffled me for hours. Thanks, Randy |