Is there anyway to write a function that takes as input a string containing
a formula and then somehow executes it and returns the value?

MyExecuteFunction("sum(a2:c5)")

I basically want the user to write out a normal worksheet formula and then I
need to parse this formula, make some changes and return back the value.

Is there anyway to do this?