=IF(ISBLANK(G2),"",(F1)) works.

However, it gives me the value in F1 not the formula used in F1.

Any more ideas?

"David Biddulph" wrote:

In F2 use the formula =IF(ISBLANK(G2),"",F1)

I'm assuming that if G2 is blank then you want F2 blank too?
--
David Biddulph

"E Cobb" wrote in message
...
I'm trying to do a conditional:
F1 is a formula that works.

This is the end result I'm looking for.

If cell (g2) has any text or is not blank Then I want that cell (F2) to
equal the formula from cell (F1) (modified appropriately for this new
cell)
Then the same applies for F3, copy formula from F2.

Any help?