Is it possible to use indirect to dynamically call different excel functions?
For example, cells A2:A10 contain my raw data, named “data”,
Cell B2 contains the text “stdev”.
Cell B3 contains the text “average”.
In cell C2, I want to calculate stdev(data),
In cell C3, I want to calculate average(data).
By changing C2 from “stdev” to “max” C2 should now calculate max(data)
My formula: “= indirect (b2)(data)” does not work. Excel replaces the formula with = indirect (b2)*(data) which is not what I want and also results in a #SPILL! error.
New contributor
Gary Zigmond is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.