+ Reply to Thread
Results 1 to 2 of 2

Order Form Sub-Totals and Total Amounts Help

  1. #1
    Registered User
    Join Date
    08-29-2006
    Posts
    32

    Order Form Sub-Totals and Total Amounts Help

    I am building an order form in excel. The order form is going to be divided into at two pages in length. Each successive page, will carry forward the sub-total from the previous page.

    If the order form only has enough entries to occupy one page, the sub-total, and discounts are tallied up and displayed at the bottom of the page in a total cost.

    If the order form goes beyond one page, how can I get the first page to not tally up the discounts and calculate the total cost? I want the discounts to be tallied up at the end of the second page with the total amount of entries and then calculate a total cost.

    It would also be nice if the first page did not display any discounts or totals, and just have this information on the second (and last page) of the order form.
    The Outdoor Accessory People

  2. #2
    Forum Contributor
    Join Date
    01-13-2006
    Location
    Texas
    Posts
    161
    I think the general solution is to keep track of the number of items on the order and based on how many fit on one page, make your totalling calcs and output for page 1 conditional on not exceeding that line count. Shouldn't be more more than a simple =IF(linecnt > ....) type of statement.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1