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))))
<tbody>
</tbody>
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))))
Column A | Column B | Column C | Column D | Column E | Column F |
Row 1 | Month 1 | Month 2 | Month 3 | Month 4 | Toggle |
Row 2 | 100 | 700 | 1,300 | 200 | |
Row 3 (RESULT) | 3 | 6 |
<tbody>
</tbody>