View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Brian
 
Posts: n/a
Default 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?