You can get the formular string but it will not calculate automatically.
In B1: =IF(A1<=4, FORMULATEXT(D1),"")
In C1: =IF(A1<=4, FORMULATEXT(E1),FORMULATEXT(F1))
I don't know how to activate calculation of these formular string.
If you accept auxiliary cell, "EVALUATE" works. You can select B2, Press Ctrl+F3, create a name like RAW=EVALUATE(Sheet2!B1). Then you can use =RAW to calculate formular of cell above current cell.
