Drop down list containing a formula

[ddub25]

Is there a way of creating a drop down list which contains a formula or formulas that can be selected. I've tried with Data Validation, but cant see any options for this.

Any ideas. Thanks.

Dan

 

[MisterBate5]

Do you mean a drop-down list that will result in a cell then containing a formula? If so, then no.

If you mean a drop-down list where the drop-down list values are generated by a formula, then yes.