Simple question

[smittycft99]

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.

[Audiojoe]

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

[smittycft99]

Thanks AudioJoe, I really appreciate it.

[Audiojoe]

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

[Chris Davison]

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 ]