Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: Simple question

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    128
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a drop menu with the values, "high","medium","low". I want to insert a value into another cell dependent on what the user picks. ie. if they pick "high", place a "1" value in cell C7.

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default


    Put something like:

    =if(A1="High",1,if(A1="Medium",2,if(A1="Low",3,"")))

    That's if your drop down is in cell A1. If you just want to count the number of times that High, Low or Medium comes up try:

    =countif(your range,"High") etc...

    Audiojoe

  3. #3
    Board Regular
    Join Date
    Apr 2002
    Posts
    128
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks AudioJoe, I really appreciate it.

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Where the wild roses grow
    Posts
    285
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    That's quite all right fella. I had some beers at lunch so I'm quite in the mood for helping people this afternoon

    Out of interest, it took me nearly ten attempts to type this. Man, that was good beer

  5. #5
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-03 07:29, Audiojoe wrote:

    Put something like:

    =if(A1="High",1,if(A1="Medium",2,if(A1="Low",3,"")))

    That's if your drop down is in cell A1. If you just want to count the number of times that High, Low or Medium comes up try:

    =countif(your range,"High") etc...

    Audiojoe
    Beers at lunchtime ?

    Outrageous.

    Audiojoe,

    if you get stuck with nested ifs like I always do, try this sort of approach :

    =VLOOKUP(A1,{1,"High";2,"Medium";3,"Low"},2,0)

    (it doesn't take care of the N/A in this particular posting, but you can catch my drift...)

    always handy



    [ This Message was edited by: Chris Davison on 2002-05-03 13:15 ]

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •