1. Due to the recent site upgrade, the iPadForums (iPF) App will no longer work. The new iPadForums.net website has been designed from the ground up to work perfectly from any mobile, tablet, or desktop computer using the built in internet browser. Create a shortcut to iPadForums.net on your home screen by following these steps: Create an icon for iPadForums.net

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,744
  2. Acuratech78
    Replies:
    5
    Views:
    20,682
  3. tawcat
    Replies:
    1
    Views:
    1,619
  4. JAMESSTAR
    Replies:
    0
    Views:
    543
  5. cuencageek
    Replies:
    3
    Views:
    15,618
Loading...

Share This Page