Calc conditional drop-menu [closed]
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.
@GuitarEC -- Did mariosv's answer work for you? Are you still looking for an answer?