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

Code	Shop	Badge	Name	Start Date	On Board	Net Hours	4/13/2019
1426	94	54321	Deyd	10/15/2015	3	1748
1427	94	43267	Harry	9/8/1987	31	1748
1432	94	67890	Sam	2/8/2014	5	1748
1452	81	58491	Steve	3/25/2000	19	1748
1458	81	40986	Has	3/26/2000	19	1748
1457	94	32167	Dood	3/27/2000	19	1748
1459	86	21567	Gene	3/28/2000	19	1748
1457	45	31256	Allan	3/29/2000	19	1748
1432	56	98673	Joe	3/30/2000	19	1748
1489	58	78546	Smith	3/31/2000	19	1748
1478	45	98321	Evan	4/1/2000	19	1748
1475	47	12678	dan	4/2/2000	19	1748
1466	69	63146	mell	4/3/2000	19	1748
1243	99	51396	Wit	4/4/2000	19	1748
1488	82	43218	Pit	4/5/2000	19	1748
1469	56	32109	****	4/6/2000	19	1748
1423	75	21645	Sit	4/7/2000	19	1748
1411	42	92574	Walk	4/8/2000	19	1748
1410	88	50912	Fall	4/9/2000	19	1748
1412	54	31267	Stop	4/10/2000	19	1748

<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>
</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