Ask Your Question

Calc conditional drop-menu [closed]

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

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...


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


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

qubit gravatar imagequbit ( 2013-03-13 04:56:15 +0200 )edit

1 Answer

Sort by » oldest newest most voted

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

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


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 +0200 )edit

Question Tools



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

Seen: 1,654 times

Last updated: Mar 26 '12