Forum Discussion

HVAC-Designer0202's avatar
HVAC-Designer0202
Copper Contributor
Dec 30, 2022

Formulas and Functions

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

Formulas and Functions
  • XXplore's avatar
    XXplore
    Brass Contributor
    Dec 30, 2022

    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.

Resources