Insert formula via data validation

[candeniz]

In Data validation list I defined formulas: ,=1.5+($B$1/$B$2),=2+($B$1/$B$2)*2,=2.7+($B$1/$B$2)*3 ..... and works well for me because I can see all formulas in dropdown list as they are to choose the appropriate one.


But I prefer to define them in a named range since number of formulas are around 20. Unfortunately I can see only the results instead of formula origins in dropdown list when I define as named range so makes me choose the suitable one impossible.


I wonder whether to see the formulas itself when I defined in named range or any other method.

Thanks in advance.

 

[AlphaFrog]

When you put the formulas in the named range, precede them with a single quote so they become a text string..

'=1.5+($B$1/$B$2)

 

[candeniz]

True but does not help me because I need autocalculation after selection