+ Reply to Thread
Results 1 to 2 of 2

quantity determines price

  1. 01-06-2019, 08:12 PM #1
    gocolonel77
    gocolonel77 is offline
    Forum Contributor
    Join Date
    08-24-2011
    Location
    Van Wert, Ohio
    MS-Off Ver
    Excel 2010, 2000
    Posts
    104

    quantity determines price

    If cell F3 is the quantity, I would like a formula in G3 to compute the following scenario.

    If a customer orders between 50-99 widgets, then the price will be 1.45 each.

    If a customer order greater than 99 widgets then the price will be 1.35 each.

    Thanks and in advance
    Reply With QuoteRegister To Reply
  2. 01-06-2019, 08:19 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: quantity determines price

    A
    B
    C
    1
    Qty
    Price
    2
    50
    72.50
    		 B2: =IF(A2 < 100, 1.45, 1.35) * A2
    3
    99
    143.55
    4
    100
    135.00
    5
    101
    136.35
    6
    102
    137.70
    7
    103
    139.05
    8
    104
    140.40
    9
    105
    141.75
    10
    106
    143.10
    11
    107
    144.45
    12
    108
    145.80
    Entia non sunt multiplicanda sine necessitate
    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] Sum quantity and price based on first 2 characters
    By gan_xl in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-05-2018, 06:12 AM
  2. [SOLVED] Calculating price by size of pipe and quantity than ranges in price per amount and size
    By scoilersfan in forum Excel General
    Replies: 4
    Last Post: 01-20-2018, 01:49 PM
  3. Formula that determines selling price
    By couevans in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-24-2017, 06:16 PM
  4. [SOLVED] Setting a selling price based on cost price and order quantity
    By Steven811 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-11-2014, 08:07 AM
  5. [SOLVED] Formula/macro that determines required sale price to satisfy input IRR
    By djh30 in forum Excel General
    Replies: 3
    Last Post: 03-19-2014, 12:05 PM
  6. Calculate price based on quantity
    By DieselNash in forum Excel General
    Replies: 5
    Last Post: 04-21-2009, 10:51 AM
  7. =SUM(Price*Quantity) and microsoft help is no help at all
    By Lissa_Jayne in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 08-24-2006, 07:15 AM

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