Results 1 to 7 of 7

what function to use to calculate a value based on drop down list

Threaded View

  1. #1
    Registered User
    Join Date
    07-14-2020
    Location
    Prague
    MS-Off Ver
    MS Office 2016
    Posts
    24

    Question what function to use to calculate a value based on drop down list

    hi all,

    I am seeking for help what function shall I use to be able to calculate total value based on selected drop down list e.g.

    Cell A4 has drop down list Hrs/MD
    Cell B2 has value on Hrs =$22
    Cell C2 has value on MD = $176
    Cell D4 has value in units = e.g 10
    cell E4 = total value base on selected drop down list

    E.g. I select Hrs in A4, D4 has 10 Units, E4 = $220
    E.g. I select MD in A4, D4 has 10 units, E4 = $1760

    thanks for the help
    H.
    Last edited by HelenaG; 02-05-2022 at 10:25 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to Calculate Amount based on Drop List
    By Wit24 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-10-2021, 09:16 AM
  2. [SOLVED] Index or Lookup function based on 2 drop down list to extract data from one sheet to anoth
    By FrancisM2411 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-20-2018, 12:43 PM
  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. How to create a drop down list based on the choices of another drop down list?
    By Happy jain in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2013, 01:54 AM
  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. Calculate a date based on a drop down list
    By YNWA in forum Excel General
    Replies: 4
    Last Post: 06-08-2012, 08:17 PM

Tags for this Thread

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