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.
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.
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-03-26 22:32:33 +0200
Seen: 228 times
Last updated: Mar 26 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
@GuitarEC -- Did mariosv's answer work for you? Are you still looking for an answer?
qubit ( 2013-03-13 04:56:15 +0200 )edit