+ Reply to Thread
Results 1 to 2 of 2

Static Cost multiplied by user defined quantity

  1. 10-09-2019, 02:06 PM #1
    Mookie88
    Mookie88 is offline
    Registered User
    Join Date
    10-09-2019
    Location
    Halifax, NS
    MS-Off Ver
    10
    Posts
    1

    Static Cost multiplied by user defined quantity

    Hi there, I have a column of prices which remain static regardless of # ordered.

    I want the user to be able to input any random # into a cell and it populate the total cost... it seems easy but I am such a newbie... : (
    Attached Files Attached Files
    Last edited by Mookie88; 10-09-2019 at 02:19 PM. Reason: sheet
    Reply With QuoteRegister To Reply
  2. 10-09-2019, 02:52 PM #2
    Bernie Deitrick
    Bernie Deitrick is offline
    Forum Expert
    Join Date
    02-11-2014
    Location
    New York
    MS-Off Ver
    Excel 365 (Windows)
    Posts
    5,943

    Re: Static Cost multiplied by user defined quantity

    Enter the numbers into column F
    Attached Files Attached Files
    Bernie Deitrick
    Excel MVP 2000-2010
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA: Auto-fill cells based on user defined values and quantity
    By Dracius in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 03-24-2018, 03:46 PM
  2. IF statement that looks at quantity in cell to determine which cells get multiplied
    By madrick1991 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-07-2015, 12:07 PM
  3. [SOLVED] SUM cells with same content and multiplied by quantity of each
    By t.regi in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-09-2014, 01:01 AM
  4. Drop down box quantity multiplied by cost, to be placed in a cell on another sheet
    By Terrydorset in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 02-08-2013, 04:08 PM
  5. Need to calculate minimum lot quantity with a changing variable cost
    By BCarson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-28-2012, 09:38 AM
  6. [SOLVED] User Defined Function is static
    By zoudazou in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-29-2012, 08:53 PM
  7. Pivotable Sum of Cost times Quantity
    By Jim Pockmire in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-16-2006, 08:00 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1