A formula in a data validation drop down list

Occasional Contributor

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

2 Replies


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.