View Single Post
  #1   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

Im trying to do a conditional:
F1 is a formula that works.

This is the end result Im 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?