... e.g cell B6 contains the original formula, i could select
another cell say C6 an insert a formula
=IFB6=blank, insert formula... or similar?

Perhaps something like this in C6:
=IF(B6="","",B6*100)

C6 will appear "blank" if B6 is either empty, or if B6 contains a formula
evaluating to a null string:"", otherwise C6 returns the result of the calc:
B6*100

Replace the part: B6*100 with your formula ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dannycol" wrote:
Anyone know if it is possible to assign a formula to a cell, only if the cell
is blank?

e.g. i have cells with formula in where data is linked to other cells,
sometimes however this data my be manually deleted leaving the cell blank, i
would like the cell to retain the original formula or the formula be re
inputed if the cell is blank, so that if again the formula criteria is met
the correct data/value is retuned.

i was hoping, e.g cell B6 contains the original formula, i could select
another cell say C6 an insert a formula =IFB6=blank, insert formula... or
similar?

Any help would be appreciated

Danny