Extra Credit, IF funtion _6 - Excel O Search (Alt+O) AutoSave Off Data Review Formulas View Help File Home Insert Draw Page Layout ' ' 11 == Currency Wrap Text LE Arial Paste Merge & Center $ % 90 Conditional Formatting a. A- B I U v Number Font Alignment 19 Clipboard B24 fx F G H D A B 1 Business Rules 2 Payments Days = Date Paid - Purchase Date 3 Finance Charge = Use the IF function. IF Payment Days > 30 then Finance Charge = Sales Amount * 5% 4 Else Finance Charge = 0. 5 Amount Due = Sales Amount + Finance Charge 6 Total Finance Charge = Use the Sum function 7 Accounts Overdue = Use the Countif function (Finance Charge > 0) 8 Wilson's Sales = Use the Sumif function 9 Jones Sales = Use the Sumif function 10 Use Conditional formatting on the Finance Charge to make the Finance Charge bold if > 0. 11 12 GALAXY CANDY COMPANY 13 Overdue Accounts Report 14 15 Company Name Salesperson Purchase Date Date Paid Payment Days Sales Amount Finance Charge Amount Due 16 Can Can Candy Wilson 8/12/2011 10/1/2011 $700.00 17 Cathy's Candies Jones 8/15/2011 9/2/2011 $900.00 18 Sweet Tooth Jones 8/18/2011 9/21/2011 $600.00 19 The Candy Man Wilson 8/22/2011 9/2/2011 $1.000.00 20 The Sweet Shop Jones 8/24/2011 9/30/2011 $800.00 21 Heavenly Candies Wilson 9/1/2011 9/22/2011 $400.00 22 Total Finance Charge 23 Accounts Overdue Simple IF (20 points) Galaxy Candy (25 points) Gradebook (30 points) | Ready