Spreadsheet: 886324d1736351226-multiple-if-with-or-functions-depending-on-between-bonus-calculation-if-functions
Sheet: Sheet2

 |  |  |  |  |  | 0.91 |  | 0.92 |  | 0.93 |  | 0.9400000000000001 |  | 0.9500000000000001 |  | 0.9600000000000001 |  | 0.9700000000000001 |  | 0.9800000000000001 |  | 0.9900000000000001 |  | 1
 |  |  | Revenue €/hr |  | 75
 |  |  |  |  |  | Available for Bonus at 91% |  | Available for Bonus at 92% |  | Available for Bonus at 93% |  | Available for Bonus @ 94% |  | Available for Bonus @ 95% |  | Available for Bonus @ 96% |  | Available for Bonus @ 97% |  | Available for Bonus @ 98% |  | Available for Bonus @ 99% |  | Available for Bonus @ 100% |  | ACTUAL HOURS WORKED |  |  |  |  | ACTUAL BONUS THEY ARE ENTITLED TO
 | Employee Name | Annual hours available | Hours to be sold | 0.9 |  | 0.4 |  | 0.4 |  | 0.4 |  | 0.4 |  | 0.4 |  | 0.4 |  | 0.4 |  | 0.4 |  | 0.4 |  | 0.4 |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | Q1 Total Hrs | % Actual Efficiency | 0.6 | 0.2 | 0.2 | 1 | Annual Bonus | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | Q2 Total Hrs | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | Q3 Total Hrs | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | Q4 Total Hrs
 | Elly | 1840 | 1674.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 500 | 500 | 550 |  |  | 0.6 | 0.2 | 0.2
 | Bazzy | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 500 | 500 |  |  | 0.6 | 0.2 | 0.2
 | [NAME] | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 500 | 500 |  |  | 0.55 | 0.1 | 0.2
 | [NAME] | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 500 | 500 |  |  | 0.6 | 0.2 | 0.2
 | Gerarld | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 500 | 500 |  |  | 0.6 | 0.2 | 0.2
 | Ronny | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 500 | 500 |  |  | 0.4 | 0.2 | 0.2
 | Betty | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 500 | 500 |  |  | 0.6 | 0.2 | 0.2
 | Rita | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 550 | 500 |  |  | 0.4 | 0.2 | 0.2
 | Carmel | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 500 | 500 |  |  | 0.6 | 0.1 | 0.05
 | [NAME] | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 500 | 500 |  |  | 0.6 | 0.2 | 0.2
 | Dermot | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 600 | 500 |  |  | 0.3 | 0.2 | 0.2
 | Cillian | 1725 | 1569.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 500 | 500 |  |  | 0.6 | 0.1 | 0.2
 | [NAME] | 1840 | 1674.4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 450 | 650 | 500 |  |  | 0.55 | 0.2 | 0.2
 |  |  |  | 0.3 | 0.3
Apprentice | [NAME] | 1725 | 517.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6 | 0.2 | 0.2
Apprentice | [NAME] | 1840 | 552 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6 | 0.2 | 0.2
Apprentice | [NAME] | 1725 | 517.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.6 | 0.2 | 0.2
 | 40% of Additional Revenue available for Bonuses