What's new
Apple iPad Forum 🍎

Welcome to the Apple iPad Forum, your one stop source for all things iPad. Register a free account today to become a member! Once signed in, you'll be able to participate on this site by adding your own topics and posts, as well as connect with other members through your own private inbox!

Check box and printing

Twinjayhawks

iPF Noob
Joined
Nov 29, 2012
Messages
1
Reaction score
0
Location
Tulsa, OK
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?
 

iNotes4You

iPF Noob
Joined
Nov 30, 2012
Messages
14
Reaction score
1
Location
GERMANY
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:

Most reactions

Latest posts

Top