Free Trial

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
Share this Page URL
Help

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.

image with no caption
Exercise

Here is a spreadsheet to help you split up the expenses for the restaurant bills you paid for.

  1. Fill in the blanks for Bob and Sasha using the values on the facing page.

  2. 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.

  3. Select the formula you just wrote in cell E4 and copy/paste it for meals 2–4. What happens? Look at the references for each result.


  

You are currently reading a PREVIEW of this book.

                                                                                        

Get instant access to over
$1 million worth of books and videos.

  

Start a Free Trial