Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.
- Create BookmarkCreate Bookmark
- Create Note or TagCreate Note or Tag
- PrintPrint
1. Introduction to Formulas: Excel’s rea... > Your friends agree: split the checks...
Your friends agree: split the checks individually
Since you’re going to the trouble to create a spreadsheet for your dining expenses, you might as well go ahead and break each check down individually. This approach will give the most equitable results.
Here are the receipts for the meals you bought yourself.
Here is a spreadsheet to help you split up the expenses for the restaurant bills you paid for.
-
Fill in the blanks for Bob and Sasha using the values on the facing page.
-
Now, write a formula to calculate your share of meal #1. Instead of adding elements from the facing page, just subtract what Bob and Sasha spent from the total.
-
Select the formula you just wrote in cell
E4and copy/paste it for meals 2–4. What happens? Look at the references for each result.
