SortingCautions

SortingCautions - Buyer Price Total Absalom $100 $5.50...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
LIST SORTING and FORMULAS 1.  A row-wise sort is fine. The total column formula references only values in its own row. Buyer Tax Price Total Absalom 4% $100  $4  Bernardo 5% $100  $5  Collins 10% $100  $10  Tax: 5.50% 2.  A row-wise sort is fine. The total column formula references the external tax rate using an absolute reference.
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Buyer Price Total Absalom $100 $5.50 Bernardo $200 $11.00 Collins $300 $16.50 3. With a left-right sort, any formula references must be to values in the same column. Absalom Bernardo Collins 55 105 205 110 210 410 220 420 820...
View Full Document

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Ask a homework question - tutors are online