Spreadsheet: 273981d1382976955-problem-with-nested-ifs-and-something-else-bonus-worksheet
Sheet: Sheet1

 | NAMENAMENAME |  | 12345
 | Big Stuff |  |  |  |  |  |  | Lil' stuff |  |  |  |  |  | Little stuff formula (Row 5 only)
DATE | Model | Price | Qty. | Bonuses | Check numb. |  | DATE | Model | Price | Qty. | Bonuses | Check numb. |  | Req Met? | Top Bonus | 2nd Bonus
2013-08-30 00:00:00 | ESF 6630 ROX | 420 | 1 |  | 73696 |  | 2013-08-30 00:00:00 | ZEO 5430 | 69.99 | 1 |  | 73692
2013-09-01 00:00:00 | EN 2900 ADX | 249.99 | 1 |  | 4680 |  | 2013-08-30 00:00:00 | ZB 2941 | 119.99 | 1 |  | 4238 |  |  |  | Combine bonus
2013-09-07 00:00:00 | EN 2900 ADW | 212.49 | 1 |  | 101273 |  | 2013-08-31 00:00:00 | ZB 2943 | 119.99 | 1 |  | 73763
2013-09-08 00:00:00 | EC 220 | 209 | 1 |  | 101366 |  | 2013-08-31 00:00:00 | [NAME] | 99.99 | 1 |  | 73792 |  |  |  | Set IF for Req Met
2013-09-08 00:00:00 | EN 3450 AOW | 322.99 | 1 |  | 75208 |  | 2013-08-31 00:00:00 | [NAME] | 99.99 | 1 |  | 73806
2013-09-08 00:00:00 | EOC 69400X | 509.99 | 1 |  | 75212 |  | 2013-09-01 00:00:00 | ZUS 3932 G | 149.99 | 1 |  | 101049 |  |  |  | [NAME]
2013-09-08 00:00:00 | EN 2900 ADW | 212.49 | 1 |  | 5943 |  | 2013-09-01 00:00:00 | ZUS 3932 G | 149.99 | 1 |  | 101049
2013-09-08 00:00:00 | EWW 1686 HDW | 526 | 1 |  | 5950 |  | 2013-09-06 00:00:00 | ZUP 3820 B | 111.99 | 1 |  | 4582 |  | [NAME]
2013-09-13 00:00:00 | EN 3401 AOW | 299.99 | 1 |  | 75837 |  | 2013-09-06 00:00:00 | Z 8870 | 191.99 | 1 |  | 5612
2013-09-14 00:00:00 | EDH 3386 GDW | 489 | 1 |  | 6955 |  | 2013-09-07 00:00:00 | ZEO 5410 | 41.99 | 1 |  | 101246
2013-09-15 00:00:00 | EWW 1486 HDW | 499.99 | 1 |  | 7062 |  | 2013-09-07 00:00:00 | ZB 5012 | 84.99 | 1 |  | 101279
2013-09-27 00:00:00 | EWP 1074 TDW | 239.99 | 1 |  | 8993 |  | 2013-09-07 00:00:00 | ESTM 6400 | 47.99 | 1 |  | 101246
2013-09-28 00:00:00 | EKC 51100 OW | 249 | 1 |  | 77699 |  | 2013-09-14 00:00:00 | EFB 60550 BX | 269.99 | 1 |  | 6931
2013-09-28 00:00:00 | EN 3450 AOW | 349 | 1 |  | 77699 |  | 2013-09-15 00:00:00 | Z 8870 | 239.99 | 1 |  | 7062
2013-09-28 00:00:00 | EWW 1786 HDW | 629.99 | 1 |  | 2456 |  | 2013-09-15 00:00:00 | [NAME] | 69 | 1 |  | 76131
2013-09-29 00:00:00 | EWT 1266 EDW | 329.99 | 1 |  | 3259 |  | 2013-09-15 00:00:00 | ZE 320 A | 85 | 1 |  | 7104
2013-09-29 00:00:00 | T76280 AC | 479.99 | 1 |  | 77940 |  | 2013-09-28 00:00:00 | ZB 2943 | 119.99 | 1 |  | 77765
TOTAL: |  |  |  |  |  |  | TOTAL:
DATE | Hours | Big stuff | Lil' stuff |  | Bonus Calculation
2013-08-30 00:00:00 | 4h |  |  |  | Type | Item price | Bonus Ls
2013-08-31 00:00:00 | 4h |  |  |  | Big stuff | 250 | 2
2013-09-01 00:00:00 | 4h |  |  |  | Big stuff | 450 | 3.5
2013-09-06 00:00:00 | 4h |  |  |  | Big stuff | 700 | 5
2013-09-07 00:00:00 | 4h |  |  |  | Big stuff | 1000 | 7.5
2013-09-08 00:00:00 | 4h |  |  |  | Little stuff | 90 | 1.5
2013-09-13 00:00:00 | 4h |  |  |  | Little stuff | 120 | 3
2013-09-14 00:00:00 | 4h |  |  |  | Requirements | Total Price | Qty
2013-09-15 00:00:00 | 4h |  |  |  | Big stuff | 355 | 3
2013-09-27 00:00:00 | 4h |  |  |  | Little stuff | 120 | 3
2013-09-28 00:00:00 | 4h
2013-09-29 00:00:00 | 4h |  |  |  | Minimum requirements on big stuff, to claim a bonus - 3 sold items a day or 355Ls a day.
 |  |  |  |  | Minimum requirements on little stuff, to claim a bonus - 3 sold items a day or 120Ls a day.