+ Reply to Thread
Results 1 to 2 of 2

Creating IF formula based off drop-down list selection

  1. #1
    Registered User
    Join Date
    09-27-2018
    Location
    Wichita, Ks
    MS-Off Ver
    2016
    Posts
    1

    Creating IF formula based off drop-down list selection

    I understand Excel basics, but this one has me stumped. Ideally, I would like a cell to multiply the value from another cell based on the selection made from a dropdown list. So it would go something like this: Dropdown list is in cell A1. "Promotion XYZ - 20% off" is the selection made from the list. Cell B1 displays the standard retail value of a product at $100. Cell C1 is where I've been trying to build an IF formula that would display the promotional rate, which would ultimately be B1*0.2 ($80). There are multiple promotion selections to choose from and varying standard retail values. These are quotes that will be sent to customers and I would like my team to be able to make selections and have the sheet do the math for them versus relying on them to do the math themselves. Any help is greatly appreciated!!

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,499

    Re: Creating IF formula based off drop-down list selection

    sounds like a vlookup would do the trick. this assumes you have the dropdown list already so it uses a vlookup in C1 referencing a table and return the results.
    make changes to locations of cells as you need.
    Attached Files Attached Files
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 5
    Last Post: 07-13-2016, 03:39 PM
  2. Change reference cell in formula based on selection in drop down list
    By devin.fentie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-13-2016, 03:40 AM
  3. [SOLVED] Clear up to three dependent drop down lists based on selection in superior drop down list
    By theletterh in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 09:31 PM
  4. Moving YTD Formula Based on drop down list month selection
    By Webbn111 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-28-2014, 02:22 PM
  5. Populate Drop-down list based on selection from previous drop-down list
    By Diventus in forum Excel - New Users/Basics
    Replies: 14
    Last Post: 01-11-2013, 10:55 AM
  6. Populate Drop-down list based on selection from previous drop-down list
    By poison_stone in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 12-11-2012, 06:10 PM
  7. Replies: 1
    Last Post: 12-01-2010, 04:51 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1