Cost times amount (if populated)

[Guest]

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?

 

[renegan]

Try to put this on column H rows:
=If(Isblank(G1),0,A1*6)

 

[Bob Phillips]

=IF(G2="",0,A2*6)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[ChuckF]

Brian, I am not sure exactly what you are trying to do. If column H
lists the price and you want the total dollar amount to appear in I
then in I type the following
=IF(A1=0,"",A1*H1)

If ALL the shirts are 6 you can simply do this in H
=IF(A1=0,"",A1*6)

Does this help?

 

[Guest]

Nailed it ! Thanks.

=IF(G2="",0,A2*6)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Guest]

yes, thanks

 

[Guest]

Thanks