Results 1 to 4 of 4

Making drop-down options more user friendly while retaining formula functionality

Threaded View

  1. #1
    Registered User
    Join Date
    03-12-2018
    Location
    UK
    MS-Off Ver
    2016
    Posts
    4

    Making drop-down options more user friendly while retaining formula functionality

    Hello,

    I am making a fairly complex sheet, but struggling with one part of a calculating form I need to add in, I suspect it's quite simple.

    I have created a form that utilises 3 different variables to give me a total. Two of these are simple numerical entries, the third is a drop-down option.

    My issue is that I want the drop-down option to be user friendly for the audience it is going to be used by. The rule I need is to add a different percentage for different year options in the drop-down (e.g. selecting 2 years will add 4%).

    As an example, if I enter 10 in the first cell (cell C5), £50 in the second (cell C8), and the drop-down option in the third (cell C11), I should get the result £20. This gives me the formula =SUM((C5*C8)*C11).

    If I write the numbers (in the above example it would be 0.04) as the selection for the drop-down box, the formula/form work fine, but this isn't clear enough for the people who will be using it. I can't make the option '2 days' or I get the error result #VALUE!. Is there a way to link the drop-down option to a formula but have it displayed as 'x years' in the drop-down?

    I have attached a test copy, in case anyone wants to play with it and can offer any advice. Thanks a lot!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 2
    Last Post: 03-12-2018, 11:45 AM
  2. General Formatting - Making User Friendly
    By Phonix in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 01-13-2017, 04:53 PM
  3. Replies: 8
    Last Post: 08-11-2016, 11:07 AM
  4. Replies: 8
    Last Post: 05-03-2016, 09:04 AM
  5. Drop down cell not showing all options/Significant loss in functionality
    By mdunc in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 09-04-2012, 04:21 PM
  6. Making a spreadsheet user friendly
    By quiggdavid in forum Excel General
    Replies: 10
    Last Post: 03-30-2011, 07:18 PM
  7. making a worksheet user friendly
    By lsu-i-like in forum Excel General
    Replies: 0
    Last Post: 05-06-2005, 01:29 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