+ Reply to Thread
Results 1 to 2 of 2

Using a list to change the value of a cell

  1. #1
    Registered User
    Join Date
    06-28-2012
    Location
    Eldorado
    MS-Off Ver
    Excel Starter 2010
    Posts
    2

    Using a list to change the value of a cell

    Microsoft Office Excel 2007

    Here's the thing
    I want to change the value inside a cell based on the person's choice of a value in a list.
    How do I do that?
    For example

    Options of List:
    A
    B
    C

    If you choose option A, in cell X a certain number will appear, let's say 10
    If you choose option B, in cell X another number will appear, let's say 15
    And so on

    Did I made myself clear? English is not my mother tongue.

    Thanks for the help guys.

  2. #2
    Registered User
    Join Date
    08-17-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2010
    Posts
    1

    Re: Using a list to change the value of a cell

    You can change the formula accordingly.Say the drop down is A1 what you'd want at the moment is
    =IF(A1="A","10,IF(A1="B",15,IF(A1="C",20))))

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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