ISTEXT TRUE then copy formula from cell X
I tried and it didn't work. It errors
I also tried =NOT(isblank(g2),"",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?
|