LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
stoke market accounting buy brokrej amount sell brokrej amount ISMAIL Excel Worksheet Functions 0 February 9th 06 07:49 PM
sorting multiple minimum times the swimmer Excel Discussion (Misc queries) 2 December 23rd 05 02:32 AM
multiply hours/minutes times dollars for total dollar amount Anakin0303 Excel Discussion (Misc queries) 1 December 12th 05 06:43 PM
our cost to customers cost thisguy Excel Worksheet Functions 2 July 15th 05 03:38 AM
Can you limit the amount of times a calc is performed on certain cells n_davies Excel Discussion (Misc queries) 1 January 24th 05 10:43 PM


All times are GMT +1. The time now is 04:55 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"