View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
E Cobb E Cobb is offline
external usenet poster
 
Posts: 4
Default 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?