If you are trying to copy the formula from F1, but add one to the row
numbers, the easiest way is probably just to copy F1 into F2, and then add
the extra bits around the formula
=IF(ISBLANK(G2),"",...)
--
David Biddulph

"E Cobb" wrote in message
...
Thanks David. This helps. I am assuming that I can not do 'exactly'
what I
want which is to duplicate the copy/paste special so the formula smartly
adds
a row each time it is copied.

It sounds like I will have to manually enter each cell formula with new
whatever_formula values.

Either way, I should be able to work with this. Thanks for all your
help!

"David Biddulph" wrote:

=IF(ISBLANK(G2),"",whatever_formula_you_now_want_t o_use_if_you_don't
want_F1)

"E Cobb" wrote in message
...
=IF(ISBLANK(G2),"",(F1)) works.

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

"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?