Check box and printing

Discussion in 'iWork Forum' started by Twinjayhawks, Nov 29, 2012.

  1. Twinjayhawks
    Offline

    Twinjayhawks iPF Noob

    Joined:
    Nov 29, 2012
    Messages:
    1
    Thanks Received:
    0
    Trophy Points:
    0
    Location:
    Tulsa, OK
    Ratings:
    +0 / 0
    image.jpg


    I need to create an order form.

    The form will have company A and company B. Both companies will have different prices for each item that they sell. As I go through my inventory each week I need to create a form of things I need to order. I would like to check an item to order from the cheapest company... Then print out all of the items I need to order from each company.

    Does anyone know if this is possible?
  2. iNotes4You
    Offline

    iNotes4You iPF Novice

    Joined:
    Nov 30, 2012
    Messages:
    14
    Thanks Received:
    1
    Trophy Points:
    0
    Location:
    GERMANY
    Ratings:
    +1 / 0
    Yes, it is possible.
    In brief ...
    Create a function containing an IF-Function for the cheapest price to insert in the order list.
    Best practice would be to create two sheets. First sheet contains tables with prices for vendors A and B.
    Second sheet contains the order list. Price fields of the order list are linked to the first sheet using IF-Function.

    Edited by Moderator - no blog links, please read the forum rules.
    Last edited by a moderator: Nov 30, 2012
Similar Threads
  1. Mixz1
    Replies:
    8
    Views:
    22,807
  2. Acuratech78
    Replies:
    5
    Views:
    20,753
  3. tawcat
    Replies:
    1
    Views:
    1,707
  4. JAMESSTAR
    Replies:
    0
    Views:
    573
  5. cuencageek
    Replies:
    3
    Views:
    16,313
Loading...

Share This Page