First time here? Check out the FAQ!
asked 2012-03-26 22:32:33 +0200GuitarEC
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.
...where "Drop List" offers the choice between 24 or 36...
Hope that clearly identifies what I'd like to do...
answered 2012-03-26 23:51:19 +0200mariosv
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.
Menu/Data/Validity - Tab criteria, Allow - Cell range
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