WORLDWIDE SPORTING GOODS
CUSTOMER INVOICE Line Callout 4: =IF(F13>400,F13*0.1,0) If you spend a Gross total over $400.00, then you receive a 10% Discount -- and that amount for this invoice is this amount.
 
    Invoice Date: 05/11/08
QTY PART # UNIT PRICE TOTALS
7 210                    45.50  $      318.50
2 104                       5.75  $        11.50
1 304                    89.50  $        89.50
       
  GROSS  $      419.50
  DISCOUNT  $                          41.95
       
    LESS DISC.  $      377.55