Create a custom function in Excel - Stack Overflow In cell A2, create a name EvalAbove, and in Refers To, enter =evaluate(A1) This means that if you change the formula name in B1, then B2 will change to show the changed formula, and B3 will change to show the result Thanks This works but I found that "B3" doesn't refresh unless I edit B3