Formulas and Functions

Occasional Visitor

If cell A1 is <=4 I want to copy the formula in cell D1and E1 to B1 and C1 respectively, if Cell A1 is >4 I want to copy the formula in cell F1 to C1

2 Replies
Doesn't make sense.

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.