| Input Section | | | | | | Verification: |
| Total Rental Cost | $ 1,200.00 |
| Number of Nights | 3 |
| Rental Per Night | $ 400.00 |
| Base Night Person | $ 30.00 |
| | Enter Yes if staying that night: | | | | | Cost Per Night Per Person |
| Name | Thursday | Friday | Saturday | Sunday | | Thursday | Friday | Saturday | Sunday | | Additional | Totals |
| Kyle Peterson | Yes | Yes | Yes | Yes | | ERROR:#DIV/0! | $ 30.00 | $ 30.00 | $ 30.00 | | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Ian Matheson | Yes | Yes | Yes | Yes | | ERROR:#DIV/0! | $ 30.00 | $ 30.00 | $ 30.00 | | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Isaac Pearson | Yes | Yes | Yes | Yes | | ERROR:#DIV/0! | $ 30.00 | $ 30.00 | $ 30.00 | | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Daryl Davenport | Yes | Yes | Yes | Yes | | ERROR:#VALUE! | $ 30.00 | $ 30.00 | $ 30.00 | | ERROR:#DIV/0! | ERROR:#VALUE! |
| Nick Johnson | Yes | Yes | Yes | Yes | | ERROR:#VALUE! | $ 30.00 | $ 30.00 | $ 30.00 | | | ERROR:#VALUE! |
| James Wilson | | Yes | Yes | Yes | | | $ 30.00 | $ 30.00 | $ 30.00 | | | $ 90.00 |
| Body Rogers | | Yes | Yes | Yes | | | $ 30.00 | $ 30.00 | $ 30.00 | | | $ 90.00 |
| Troy Henderson | | | Yes | Yes | | | | $ 30.00 | $ 30.00 | | | $ 60.00 |
| Hector Martinez | | | Yes | Yes | | | | $ 30.00 | $ 30.00 | | | $ 60.00 |
| Rob Turner | | | Yes | Yes | | | | $ 30.00 | $ 30.00 | | | $ 60.00 |
| # Staying | 0 | 0 | 0 | 0 | | 0 | 0 | 0 | 0 | Totals | Short | Total Paid |
| Total Paid | | | | | | ERROR:#DIV/0! | $ 210.00 | $ 300.00 | $ 300.00 | ERROR:#DIV/0! | ERROR:#DIV/0! | ERROR:#DIV/0! |
| Total Cost | | | | | | $ 400.00 | $ 400.00 | $ 400.00 | $ 400.00 | $ - 0 |
| Assumptions and Calculation Notes |
| Those who spend Thursday night split the nightly rental cost evenly. |
| Each person pays $30 per night stayed Friday, Saturday, and Sunday. |
| Kyle, Ian, Isaac, and Daryl agreed to pay any difference in the total paid and the total rental cost. |
| Cells B20:E20 should count the number of cells containing "Yes" per night. |
| Cells G20:J20 should count the number of cells containing values per night. |
| The two sets of counts should be consistent. |
| Cells G21:J21 should add the total paid per night. G22:J22 should echo the Rental Per Night cost. |
| Cells K21:K22 should total their respective total cells. |
| Cells L9:L12 should contain a logical test to determine if the first four guys will pay any shortfall in amount collected from the entire group. |
| Cell L21 should total the additional amount the four guys paid. Cell M21 should total the total amount paid in column M. |
| The calculated value in cell M21 should be match the total rental value in cell B2, K22, and the sum of K21:L21. |
Mo7ammedaziz 
e02b3ParkCity.xlsx
