It's not a perfect solution to your problem, but you can simplify multistep calculations with LET. So it would be: LET(X, A1, Y, X*2, Y+1) I just checked

It's not a perfect solution to your problem, but you can simplify multistep calculations with LET. So it would be: LET(X, A1, Y, X*2, Y+1) I just checked and the Evaluate Formula button can sequentially step through a LET. Though this doesn't give you intermediate results you can use in other calculations.