In essence I want a WHEN formula or eliminate the "else" part of the IF formula.
I have the number 15 in cell C1 which is conditionally generated else where in the workbook . I have the number 1 in cell B1 which generated the 15 in C1.
If I change the number in cell B1 to 2 the number in C1 changes to 25
I want to copy the number 15 in cell C1 to cell D1 when the number in B1 in 1 and have the number in D1 remain 15 when the number in B1 changes to 2.
In essence I want to change the content of D1 only when the content of B1 meets a specific condition.
=WHEN(B1=1,COPY(C1))