Spreadsheet: 671224d1586306927-a-proper-formula-to-calculate-depending-several-criteria-eg6
Sheet: Sayfa1

 | YELLOW ROWS are with Data Validation
 | Room Type | Standard Land View |  | From | 2020-05-28 00:00:00 | To | 2020-07-05 00:00:00 |  | Board | BO |  | Adult # | 3 |  | Chd-1 (y.o) | 8 |  | Chd-2 (y.o) | 11 |  | Chd-3 (y.o) |  | Chd-4 (y.o) |  |  | SUM | 333
 |  |  |  |  |  |  |  |  |  | From |  | To |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 Adt | 2 Adt | 3 Adt | 4 Adt
 | Rates are on | [NAME] |  | Base Board | BO |  |  | Period #: |  | 2020-05-01 00:00:00 | - | 2020-05-31 00:00:00
 | Room Type | Min & Max Accommodations |  |  | Price/PP | [NAME] (Room Rates) |  |  |  | PP Meal Supplements |  |  | Cumulative | Free Child Ages |  |  |  |  |  | Discounted Child Ages
 |  | Min Adt | [NAME] | [NAME] |  | 1 Adt | 2 Adt | 3 Adt | 4 Adt | BB Sup | HB Sup | FB Sup | AI Sup | 1st Child Age |  |  | 2nd Child Age |  |  | 1st Child Age |  |  | -% (PP) | 2nd Child Age |  |  | -% (PP)
 | Standard Land View | 1 | 4 | 5 | 10 | 15 | 20 | 27 | 32 | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 | Std. Pool View | 1 | 3 | 3 | 15 | 22.5 | 30 | 40.5 |  | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 | Std. Side Sea View | 1 | 3 | 4 | 20 | 30 | 40 | 54 |  | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 | Std. Sea View | 1 | 4 | 4 | 25 | 50 | 50 | 67.5 | 80 | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 | FEATURES
 | Rates are on | [NAME] |  | Base Board | BO |  |  | Period #: |  | 2020-06-01 00:00:00 | - | 2020-06-20 00:00:00
 | Room Type | Min & Max Accommodations |  |  | Price/PP | [NAME] (Room Rates) |  |  |  | PP Meal Supplements |  |  | Cumulative | Free Child Ages |  |  |  |  |  | Discounted Child Ages
 |  | Min Adt | [NAME] | [NAME] |  | 1 Adt | 2 Adt | 3 Adt | 4 Adt | BB Sup | HB Sup | FB Sup | AI Sup | 1st Child Age |  |  | 2nd Child Age |  |  | 1st Child Age |  |  | -% (PP) | 2nd Child Age |  |  | -% (PP)
 | Standard Land View | 1 | 4 | 5 | 15 | 22.5 | 30 | 40.5 | 48 | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 | Std. Pool View | 1 | 3 | 3 | 20 | 30 | 40 | 54 | 0 | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 | Std. Side Sea View | 1 | 3 | 4 | 25 | 37.5 | 50 | 67.5 | 0 | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 | FEATURES
 | Rates are on | [NAME] |  | Base Board | BO |  |  | Period #: |  | 2020-06-21 00:00:00 | - | 2020-07-07 00:00:00
 | Room Type | Min & Max Accommodations |  |  | Price/PP | [NAME] (Room Rates) |  |  |  | PP Meal Supplements |  |  | Cumulative | Free Child Ages |  |  |  |  |  | Discounted Child Ages
 |  | Min Adt | [NAME] | [NAME] |  | 1 Adt | 2 Adt | 3 Adt | 4 Adt | BB Sup | HB Sup | FB Sup | AI Sup | 1st Child Age |  |  | 2nd Child Age |  |  | 1st Child Age |  |  | -% (PP) | 2nd Child Age |  |  | -% (PP)
 | Standard Land View | 1 | 4 | 5 | 20 | 30 | 40 | 54 | 64 | 3 | 6 | 12 | 20 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 | Std. Pool View | 1 | 3 | 3 | 25 | 37.5 | 50 | 67.5 | 0 | 3 | 6 | 12 | 20 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 | Std. Side Sea View | 1 | 3 | 4 | 30 | 45 | 60 | 81 | 0 | 3 | 6 | 12 | 20 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 | Std. Sea View | 1 | 4 | 4 | 35 | 70 | 70 | 94.5 | 112 | 3 | 6 | 12 | 20 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 | Std. Garden View | 1 | 3 | 3 | 25 | 37.5 | 50 | 67.5 | 0 | 3 | 6 | 12 | 20 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 50 | 3 |  | 12 | 50
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 | FEATURES