IF formula not robust enough

[RMAllen18]

Hello,
I am trying to calculate headcount needed based off of volume. There is a toggle used in the calculation that I can say I need per 100 units of volume, per 200, etc. but I only went up to the toggle value times 4. I need the formula to possibly support a much larger volume such as 40 times the toggle number. Below is the current formula I am using. Can anyone help with a better formula to use in this scenario please?
=IF(D2>=$F$2*4,4,IF(D2>=$F$2*3,3, IF(D2>=$F$2*2,2,IF(D2>=$F$2*1,1,0))))
[TABLE="width: 600"]
<tbody>[TR]
[TD]Column A
[/TD]
[TD]Column B
[/TD]
[TD]Column C
[/TD]
[TD]Column D
[/TD]
[TD]Column E
[/TD]
[TD]Column F
[/TD]
[/TR]
[TR]
[TD]Row 1
[/TD]
[TD]Month 1
[/TD]
[TD]Month 2
[/TD]
[TD]Month 3
[/TD]
[TD]Month 4
[/TD]
[TD]Toggle
[/TD]
[/TR]
[TR]
[TD]Row 2
[/TD]
[TD][/TD]
[TD]100
[/TD]
[TD]700
[/TD]
[TD]1,300
[/TD]
[TD]200
[/TD]
[/TR]
[TR]
[TD]Row 3 (RESULT)
[/TD]
[TD][/TD]
[TD][/TD]
[TD]3
[/TD]
[TD]6
[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Andrew Poulsom]

Welcome to MrExcel.

Use a lookup table:

http://www.contextures.com/xlFunctions02.html

 

[RMAllen18]

Thanks Andrew! I don't really want another tab or hidden columns though. I was hoping to keep it simple as the finished spreadsheet already has multiple tabs which all feed into a Detailed Income Statement. Do you know any formula I can utilize with what I am calling the Toggle field?