Calc conditional drop-menu [closed]

asked 2012-03-26 22:32:33 +0100

GuitarEC
11 ●2 ●3 ●3

I have a spreadsheet that depending on other data entered, will either present a fixed value, or a drop box of possible values. Below is a formula I'm hoping can be made to work in this way.

=if(Condition,12,(if(Condition,24,(if(Condition3,Drop list,36)))))

...where "Drop List" offers the choice between 24 or 36...

Hope that clearly identifies what I'd like to do...

Thanks.

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 15:46:30.104202

Comments

@GuitarEC -- Did mariosv's answer work for you? Are you still looking for an answer?

qubit ( 2013-03-13 04:56:15 +0100 )edit

add a comment

1 Answer

Sort by » oldest newest most voted

answered 2012-03-26 23:51:19 +0100

m.a.riosv

25709 ●7 ●53 ●139

I hope a formula like this (an example) is what you are looking for.

In A3:a8 a range of selection.

In B3:b7 other range of selection.

In B1 the data to select one or other.

In C3:

Menu/Data/Validity - Tab criteria, Allow - Cell range

Source: IF(B1=1;A3:A8;B3:B8)

That's all.

edit flag offensive delete link

Comments

Don't know if this helped the OP, but it is a great answer, and illustrated a conditional that I never knew could go in a validity definition. Thanks, mariosv

Jim7fl ( 2013-11-12 14:05:03 +0100 )edit

add a comment

Question Tools

2 followers

Stats

Asked: 2012-03-26 22:32:33 +0100

Seen: 1,596 times

Last updated: Mar 26 '12

Calc conditional drop-menu [closed] edit

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp close date 2015-10-15 15:46:30.104202

Comments

1 Answer

Comments

Question Tools

Stats

Related questions

Calc conditional drop-menu [closed]

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-15 15:46:30.104202