AutoSave O 010 8 Extra Credit IF funtion & - Excel Search.ch File Home Dr Page Layout Formulas Data Review View Help X - Aria 23 Wap Test General 10 - AA== 0-A- Parte BIU- Merge & Center - $ - % Conditional Found Formatting - Table Clipboard Font Alignment Number 115 A B D E G H 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% Else Finance Charge = 0 5 Amount Due Sales Amount Finance Charge 6 Total Finance Charge = Use the Sum function 7 Accounts Overdue = Use the Courtif function (Finance Charge > 0) 8 Wison's Sales = Use the Sumif function 9 Sones Sales = Use the Sumif function 10 Use Conditional formatting on the Finance Charge to make the Finance Charge bold > 0 11 12 GALAXY CANDY COMPANY 13 Overdue Accounts Report 15 Company Name Salesperson Purchase Date Date Pad Payment Days Sales Amount Finance Charge Amount Duc 16 CanCan Candy Wilson B/12/2011 10/1/2011 S700.00 17 Caths Candies Jones 8:15/2011 1912/2011 $900 00 18 Sweet Tooth Jones 8/18/2011 921/2011 $600 00 19 The Candy Man Wilson B22/2011 9.2.2011 $1 000.00 20 The Sweet Shop Lones 8/24/2011 9.30/2011 $800.00 21. Heaven Candies Wilson 91/2011 9/22/2011 S400.00 22. Tenance Charge 23 Accounts Overdue Galaxy Candy 25 point 16 AutoSave O 010 8 Extra Credit IF funtion & - Excel Search.ch File Home Dr Page Layout Formulas Data Review View Help X - Aria 23 Wap Test General 10 - AA== 0-A- Parte BIU- Merge & Center - $ - % Conditional Found Formatting - Table Clipboard Font Alignment Number 115 A B D E G H 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% Else Finance Charge = 0 5 Amount Due Sales Amount Finance Charge 6 Total Finance Charge = Use the Sum function 7 Accounts Overdue = Use the Courtif function (Finance Charge > 0) 8 Wison's Sales = Use the Sumif function 9 Sones Sales = Use the Sumif function 10 Use Conditional formatting on the Finance Charge to make the Finance Charge bold > 0 11 12 GALAXY CANDY COMPANY 13 Overdue Accounts Report 15 Company Name Salesperson Purchase Date Date Pad Payment Days Sales Amount Finance Charge Amount Duc 16 CanCan Candy Wilson B/12/2011 10/1/2011 S700.00 17 Caths Candies Jones 8:15/2011 1912/2011 $900 00 18 Sweet Tooth Jones 8/18/2011 921/2011 $600 00 19 The Candy Man Wilson B22/2011 9.2.2011 $1 000.00 20 The Sweet Shop Lones 8/24/2011 9.30/2011 $800.00 21. Heaven Candies Wilson 91/2011 9/22/2011 S400.00 22. Tenance Charge 23 Accounts Overdue Galaxy Candy 25 point 16