Spreadsheet: 672931d1587075234-a-proper-formula-to-calculate-depending-several-criteria-eg6-zrs-r
Sheet: Sayfa1

 | YELLOW ROWS are with Data Validation
 | Room Type | Standard Land View |  | From | 2020-05-28 00:00:00 | To | 2020-05-29 00:00:00 | Nights |  | Board | BB | Adult # | 3 |  | Chd-1 (y.o) | 8 |  | Chd-2 (y.o) | 9 |  | Chd-3 (y.o) |  | Chd-4 (y.o) |  |  | SUM |  |  |  |  |  |  | Price/PP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | From |  | To |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Board | Price/PP | 1 Adt | 2 Adt | 3 Adt | 4 Adt |  |  |  |  | 1st Child Age |  | 2nd Child Age |  | 1st Child Age |  |  | 2nd Child Age
 | Rates are on | [NAME] |  | Base Board | BO |  |  | Period #: |  | 2020-05-01 00:00:00 | - | 2020-05-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cumulative |  |  |  |  | Non-Cumulative
 | Room Type | Min & Max Accommodations |  |  | Price/PP | [NAME] (Room Rates) |  |  |  | PP Meal Supplements |  |  | Cumulative | Free Child Ages |  |  |  |  |  | Discounted Child Ages |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Disc. |  | Base Rate | Adult | Disc. Chd. |  | Board
 |  | Min Adt | [NAME] | [NAME] |  | 1 Adt | 2 Adt | 3 Adt | 4 Adt | BB Supp | HB [NAME] | FB Supp | AI Supp | 1st Child Age |  |  | 2nd Child Age |  |  | 1st Child Age |  |  | -% (PP) | 2nd Child Age |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | days | Adults | Children | Price/PP | Per Day | Board PD | Board PD | Chd disc | Mult | PD | PD | PD | PD | PD | PD | PD | PD
 | 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 | 3 | 3 |  | 12 | 3
 | Std. Side Sea View | 1 | 3 | 4 | 20 | 30 | 40 | 54 |  | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 3 | 3 |  | 12 | 3
 | Std. Sea View | 1 | 4 | 4 | 25 | 50 | 50 | 67.5 | 80 | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 3 | 3 |  | 12 | 3
 |  |  |  |  |  | 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 |  |  |  | Free Child Ages |  |  |  |  |  | Discounted Child Ages
 |  | Min Adt | [NAME] | [NAME] |  | 1 Adt | 2 Adt | 3 Adt | 4 Adt | BB Supp | HB [NAME] | FB Supp | AI Supp | 1st Child Age |  |  | 2nd Child Age |  |  | 1st Child Age |  |  |  | 2nd Child Age
 | Standard Land View | 1 | 4 | 5 | 15 | 22.5 | 30 | 40.5 | 48 | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 3 | 3 |  | 12 | 3
 | Std. Pool View | 1 | 3 | 3 | 20 | 30 | 40 | 54 | 0 | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 3 | 3 |  | 12 | 3
 | Std. Side Sea View | 1 | 3 | 4 | 25 | 37.5 | 50 | 67.5 | 0 | 2 | 5 | 10 | 15 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 3 | 3 |  | 12 | 3
 |  |  |  |  |  | 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 |  |  |  | Free Child Ages |  |  |  |  |  | Discounted Child Ages
 |  | Min Adt | [NAME] | [NAME] |  | 1 Adt | 2 Adt | 3 Adt | 4 Adt | BB Supp | HB [NAME] | FB Supp | AI Supp | 1st Child Age |  |  | 2nd Child Age |  |  | 1st Child Age |  |  |  | 2nd Child Age
 | Standard Land View | 1 | 4 | 5 | 20 | 30 | 40 | 54 | 64 | 3 | 6 | 12 | 20 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 3 | 3 |  | 12 | 3
 | Std. Pool View | 1 | 3 | 3 | 25 | 37.5 | 50 | 67.5 | 0 | 3 | 6 | 12 | 20 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 3 | 3 |  | 12 | 3
 | Std. Side Sea View | 1 | 3 | 4 | 30 | 45 | 60 | 81 | 0 | 3 | 6 | 12 | 20 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 3 | 3 |  | 12 | 3
 | Std. Sea View | 1 | 4 | 4 | 35 | 70 | 70 | 94.5 | 112 | 3 | 6 | 12 | 20 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 3 | 3 |  | 12 | 3
 | Std. Garden View | 1 | 3 | 3 | 25 | 37.5 | 50 | 67.5 | 0 | 3 | 6 | 12 | 20 | 0 |  | 6 | 0 |  | 2 | 7 |  | 12 | 3 | 3 |  | 12 | 3
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 |  |  |  |  |  | 0 | 0 | 0 | 0
 | FEATURES