+ Reply to Thread
Results 1 to 2 of 2

Need to create a Data Validation (list) Formula

  1. #1
    Registered User
    Join Date
    07-14-2015
    Location
    melbourne, australia
    MS-Off Ver
    2013
    Posts
    7

    Need to create a Data Validation (list) Formula

    Hi There,

    I am trying to work on a quoting formula, so that when i select a number from a drop down list it has a value i.e.: 1 = 500, 2 = 1000, and 3 = 1500 and so forth...

    I need it so that it will also automatically calculate a total in a separate column for example:

    Traffic Controllers require : 4
    Utes Required: 2
    Trucks Required: 2
    Arrowboards required: 1
    Total: $2515.00

    Please help....

    quote.xlsx
    Last edited by stax290; 08-21-2017 at 04:04 PM.

  2. #2
    Valued Forum Contributor quekbc's Avatar
    Join Date
    01-18-2010
    Location
    Sydney, Australia
    MS-Off Ver
    2010, 2013, 2016
    Posts
    1,149

    Re: Need to create a Data Validation (list) Formula

    This can be done by a series of LOOKUPs.

    Try the attached - and adjust formulas accordingly.
    Attached Files Attached Files

+ 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: 04-22-2017, 05:09 PM
  2. Replies: 6
    Last Post: 01-04-2017, 11:20 AM
  3. [SOLVED] Formula to leave cell Blank until cells of formula have data
    By mbauman in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-27-2015, 01:28 PM
  4. Replies: 0
    Last Post: 10-14-2015, 03:10 AM
  5. Replies: 1
    Last Post: 04-20-2015, 08:01 AM
  6. Replies: 1
    Last Post: 01-08-2015, 07:02 PM
  7. Replies: 1
    Last Post: 01-06-2014, 03:54 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