Does anyone know of a way to do this:

Cell 1: STDEV
Cell 2: =SUM(SomeRange)

where instead of retyping "STDEV" in Cell2 to change the function name, u
reference to Cell1 as the function name? so basically a dynamic way of
changing function name as a form of reference from another cell...

seems simple.. but never heard its been done.. hope for solution without vba
help.