software

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

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

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

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

Replace the part: B6*100 with your formula ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Dannycolquot; wrote:
gt; Anyone know if it is possible to assign a formula to a cell, only if the cell
gt; is blank?
gt;
gt; e.g. i have cells with formula in where data is linked to other cells,
gt; sometimes however this data my be manually deleted leaving the cell blank, i
gt; would like the cell to retain the original formula or the formula be re
gt; inputed if the cell is blank, so that if again the formula criteria is met
gt; the correct data/value is retuned.
gt;
gt; i was hoping, e.g cell B6 contains the original formula, i could select
gt; another cell say C6 an insert a formula =IFB6=blank, insert formula... or
gt; similar?
gt;
gt; Any help would be appreciated
gt;
gt; Danny

Thanks for the suggestion but it does not seem to solve
my query unless i've miss understood!

In B6 i have formula IF(A6gt;0,quot;Salequot;,quot;quot;) This works fine.. periodically i
have to delete the word 'Sale' leaving B6 blank which also deletes the
original formula... I'm trying to re input the original formula into B6, so
once i delete the word Sale (or delete what ever data is in B6) the formula
IF(A6gt;0,quot;Salequot;,quot;quot;) is restored in B6?

Would it be possible?

Regards

Danny

quot;Maxquot; wrote:

gt; gt; ... e.g cell B6 contains the original formula, i could select
gt; gt; another cell say C6 an insert a formula
gt; gt;=IFB6=blank, insert formula... or similar?
gt;
gt; Perhaps something like this in C6:
gt; =IF(B6=quot;quot;,quot;quot;,B6*100)
gt;
gt; C6 will appear quot;blankquot; if B6 is either empty, or if B6 contains a formula
gt; evaluating to a null string:quot;quot;, otherwise C6 returns the result of the calc:
gt; B6*100
gt;
gt; Replace the part: B6*100 with your formula ..
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Dannycolquot; wrote:
gt; gt; Anyone know if it is possible to assign a formula to a cell, only if the cell
gt; gt; is blank?
gt; gt;
gt; gt; e.g. i have cells with formula in where data is linked to other cells,
gt; gt; sometimes however this data my be manually deleted leaving the cell blank, i
gt; gt; would like the cell to retain the original formula or the formula be re
gt; gt; inputed if the cell is blank, so that if again the formula criteria is met
gt; gt; the correct data/value is retuned.
gt; gt;
gt; gt; i was hoping, e.g cell B6 contains the original formula, i could select
gt; gt; another cell say C6 an insert a formula =IFB6=blank, insert formula... or
gt; gt; similar?
gt; gt;
gt; gt; Any help would be appreciated
gt; gt;
gt; gt; Danny

What you're after is not possible via formulas.
Hang around awhile for insights from others
versed in vba.
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Dannycolquot; wrote:
gt; Thanks for the suggestion but it does not seem to solve
gt; my query unless i've miss understood!
gt;
gt; In B6 i have formula IF(A6gt;0,quot;Salequot;,quot;quot;) This works fine.. periodically i
gt; have to delete the word 'Sale' leaving B6 blank which also deletes the
gt; original formula... I'm trying to re input the original formula into B6, so
gt; once i delete the word Sale (or delete what ever data is in B6) the formula
gt; IF(A6gt;0,quot;Salequot;,quot;quot;) is restored in B6?
gt;
gt; Would it be possible?
gt;
gt; Regards
gt;
gt; Danny