Ask Your Question
1

Calc conditional drop-menu [closed]

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

GuitarEC gravatar image

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 gravatar imagequbit ( 2013-03-13 04:56:15 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

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

m.a.riosv gravatar image

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 more

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 gravatar imageJim7fl ( 2013-11-12 14:05:03 +0100 )edit

Question Tools

2 followers

Stats

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

Seen: 1,439 times

Last updated: Mar 26 '12