Forum Discussion
A formula in a data validation drop down list
when i'm putting in a formula into the list of data validation its working accept if the formula have a comma for exemple =sum(1,2) than it will got split in the list like the pictures below
You cannot use formulas as individual entries in the Source text box, in particular if they contain commas, as you have found. They wouldn't work anyway.
.png){kind=link}
.png){kind=link}
HansVogelaar thanks!