Hi, Randy

With
B6: (status....eg FT, PT, etc)
C6: (Yrs.....eg 0.5, 1, 5.5, etc)

Try something like this:
D6: =(B6="FT")*((C6=1)*4+1)+(B6="PT")*((C62)*3)

Does that help?
***********
Regards,
Ron

XL2002, WinXP


"Randy Tingley" wrote:

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