Cost times amount (if populated)
Nailed it ! Thanks.
"Bob Phillips" wrote:
=IF(G2="",0,A2*6)
--
HTH
Bob Phillips
(remove nothere from email address if mailing direct)
"Brian" wrote in message
...
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?
|