Cost times amount (if populated)
Column A is the number of shirts ordered.
Column G is the name to be printed on the shirt(s)...(if wanted).
Column H is the total cost to print the name(s) if wanted (@ $6.00 each).
How do I get the cost (Column H) to fill in based on if there is anything in
Column G (left blank for no name and if a name is wanted, type in the name)
and multiply by the quantity (Column A) for a total in Column H?
|