|
|
|
|
#1
11-22-2013, 07:26 PM
|
|||
|
|||
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. 
|
|
#2
11-22-2013, 11:41 PM
|
|||
|
|||
|
Maybe something along these lines, in E6 and copy down.
=IF(B6<>"FT","",LOOKUP(D6,{0,1,2,4},{0,5,10,15}))
|
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Creating a graph for Future Value function (FV function) | bmoody | Excel | 2 | 11-06-2013 10:52 AM |
| Adding an amount to a min-max range | Nibbles | Excel | 4 | 06-13-2013 08:05 AM |
 Data table search function
|
omtinole | Excel Programming | 1 | 07-13-2012 10:03 PM |
| amount of work | ketanco | Project | 3 | 04-06-2012 08:13 AM |
|
Data validation using indirect function
|
BullMouse | Excel | 2 | 11-30-2011 05:25 PM |
Windows Vista 
Office 2010 32bit
Hybrid Mode