Dec 29 2022 07:32 PM
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
Dec 29 2022 10:39 PM - edited Dec 29 2022 10:40 PM
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.