Spreadsheet: 85959d1285944603-excel-2007-how-to-apply-if-circumstances-dummy-workbook-1
Sheet: Choice A

60
 |  |  |  |  |  | As you can see there are fixed and variable costs…
 |  |  |  |  |  | I'm trying to make this simpler instead of having 3 different choice pages.
 |  |  |  |  |  | With my limited excel knowledge I know that you can do a drop list which I somewhat was able to successfully manage to make it work lol..
 | Weight |  | 0 |  |  | But if I can create a check box in which all these addons will be "checked" and the price will be applied that would be awesome.
 | holes |  | 0
 | cuts* |  | 0 |  | *  I usually specify the number of options applied/unit |  |  |  |  |  | These addons are fixed prices across all 3 choices and all options..
 | laser* |  | 0 |  | The cost is those options/addons are already calculated in the cells below
 | grooves* |  | 0 |  |  |  |  |  |  |  |  |  | [NAME]
 | twists* |  | 0 |  |  |  |  |  |  |  |  |  | 1.4
 | Squares* |  | 0
 | Customized Orders
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 1 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 8
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 2 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 12
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 3 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 12
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 4 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 12
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 5 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 15
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 6 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 8
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 7 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 18
 | "Larger" sizes
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 1 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 2 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 3 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 35
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 4 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 25
 |  |  |  | Material | FINISH | Holes | Laser | Grooves | Cuts | Twist | Squares | total | [NAME] | TOTAL
 |  | Option 5 |  | Cost | LABOR |  |  |  |  |  |  | cost | of | COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  | w/[NAME]
 |  |  |  |  | 35