How do you use the IF and AND function with numerouse amount of Data????
okay so here goes...i need to enter a formula using the IF and AND functions to determin the number of vacation days based on these vacation rules, 15 days for FT who worked 4 or more years, 10 days for FT who worked 2 years but less than 4, 5 days for FT who worked 1 year but less than 2 and 0 days for everyone else. this is what I have so far
=IF(AND(B6="FT",D6>=2),10,0)
my problem is that I cant figure out how to put it all intoone formula so I dont have to make up 109 of them for each person.Attached is my worksheet.
|