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