The attached Excel order form is used for placing software title orders. The information on the order form is also used to import data onto shipping labels. A code for the required software titles prints right on each FedEx label so getting the correct titles in the correct envelopes is virtually foolproof. Customers can order up to three titles for each shipment.
My problem is:
1. Any column that does not include a software title results in a return of "false".
2. "False / False..." prints on the shipping labels, which is visually confusing.
3. "False / False..." causes problems when importing this into Access for billing purposes.
My question is:
Is there an easy way to keep the basic formula structure as is, but have nothing show up instead of "False", or, is there a better way to do this altogether?
Bookmarks