Multiple Nested IF functions

[hiker8117]

Attempting to calculate the available annual man hours per production worker based on their years of service. Their annual leave both vacation and sick are based on their years on board. Knowing this I can then calculate what their true production man-hours per year are. Having trouble calculating this formula. Attached is an example spreadsheet.
The formula in net hours is. =IF(OR(F2<3),2008-208,IF(OR(F2> 3,F2<9),2008-260,IF(OR(F2>8),2008-312,0))).
I keep winding up with 1748 man-hours and I know this is not correct for each employee. Any help is appreciated.
Thank you Gene

94	54321	Deyd
94	43267	Harry
94	67890	Sam
81	58491	Steve
81	40986	Has
94	32167	Dood
86	21567	Gene
45	31256	Allan
56	98673	Joe
58	78546	Smith
45	98321	Evan
47	12678	dan
69	63146	mell
99	51396	Wit
82	43218	Pit
56	32109	****
75	21645	Sit
42	92574	Walk
88	50912	Fall
54	31267	Stop

<colgroup><col style="mso-width-source:userset;mso-width-alt:1536;width:32pt" width="42"> <col style="mso-width-source:userset;mso-width-alt:1389;width:29pt" width="38"> <col style="mso-width-source:userset;mso-width-alt:1645;width:34pt" width="45"> <col style="mso-width-source:userset;mso-width-alt:1609;width:33pt" width="44"> <col style="mso-width-source:userset;mso-width-alt:2742;width:56pt" width="75"> <col style="mso-width-source:userset;mso-width-alt:3072;width:63pt" width="84"> <col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3803;width:78pt" width="104"> </colgroup><tbody>
[TD="class: xl63, width: 42"]Code[/TD]
[TD="width: 38"]Shop[/TD]
[TD="width: 45"]Badge[/TD]
[TD="width: 44"]Name[/TD]
[TD="width: 75"]Start Date[/TD]
[TD="class: xl64, width: 84"]On Board[/TD]
[TD="width: 64"]Net Hours[/TD]
[TD="class: xl64, width: 104, align: right"]4/13/2019[/TD]

[TD="class: xl63"]1426[/TD]

[TD="class: xl64, align: right"]10/15/2015[/TD]
[TD="align: right"]3[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1427[/TD]

[TD="class: xl64, align: right"]9/8/1987[/TD]
[TD="align: right"]31[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1432[/TD]

[TD="class: xl64, align: right"]2/8/2014[/TD]
[TD="align: right"]5[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1452[/TD]

[TD="class: xl64, align: right"]3/25/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1458[/TD]

[TD="class: xl64, align: right"]3/26/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1457[/TD]

[TD="class: xl64, align: right"]3/27/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1459[/TD]

[TD="class: xl64, align: right"]3/28/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1457[/TD]

[TD="class: xl64, align: right"]3/29/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1432[/TD]

[TD="class: xl64, align: right"]3/30/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1489[/TD]

[TD="class: xl64, align: right"]3/31/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1478[/TD]

[TD="class: xl64, align: right"]4/1/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1475[/TD]

[TD="class: xl64, align: right"]4/2/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1466[/TD]

[TD="class: xl64, align: right"]4/3/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1243[/TD]

[TD="class: xl64, align: right"]4/4/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1488[/TD]

[TD="class: xl64, align: right"]4/5/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1469[/TD]

[TD="class: xl64, align: right"]4/6/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1423[/TD]

[TD="class: xl64, align: right"]4/7/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1411[/TD]

[TD="class: xl64, align: right"]4/8/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1410[/TD]

[TD="class: xl64, align: right"]4/9/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

[TD="class: xl63"]1412[/TD]

[TD="class: xl64, align: right"]4/10/2000[/TD]
[TD="align: right"]19[/TD]
[TD="align: right"]1748[/TD]

</tbody>

 

[Fluff]

Maybe
=IF(F2<=3,2008-208,IF(F2<=8,2008-260,2008-312))

 

[hiker8117]

Fluff,

Less than 3 years they get x number of hours. Between 3 and 8 years they get Y number of hours and beyond 8 they get Z number of hours.

I have to set it up such that less than 3 years equals 1800 man-hours..between 3 and 8 equals 1748 man-hours and beyond 8 equals 1696. I may not have made myself perfectly clear. Thanks for your response.

Regards

Gene

 

[Fluff]

In that case just change the <= to <

 

[hiker8117]

Thank you...

 

[Fluff]

You're welcome