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?

Cost times amount (if populated)
 

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


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=535096

Cost times amount (if populated)
 

=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?

Cost times amount (if populated)
 

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?

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?

Cost times amount (if populated)
 

yes, thanks

"ChuckF" wrote:

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?

Cost times amount (if populated)
 

Thanks

"renegan" wrote:


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


--
renegan
------------------------------------------------------------------------
renegan's Profile: http://www.excelforum.com/member.php...o&userid=10450
View this thread: http://www.excelforum.com/showthread...hreadid=535096