Cell keeps the formula even after changing the value manually

[Hina]

Hi,

I created a spreadsheet to analyze data using nested IF statements. But now,
literally I'm stuck in a loop here.

I want the cell to retain its formula. Lets assume, according to formula in
cell A1, the value is "Yes" in cell A1. Now if I change the value in cell A1
to "" (blank space) manually, the formula will get erased. Is there a way
around this, that cell keeps its formula?

Thank you
-Hina

 

[FSt1]

hi
typing in cell A1 will replace the formula with whatever you typed into the
cell. no way around this. that is how excel works. but i don't think that is
your problem. why would you want to type "" into the cell?

regards
FSt1

 

[Ron Rosenfeld]

Hi,

I created a spreadsheet to analyze data using nested IF statements. But now,
literally I'm stuck in a loop here.

I want the cell to retain its formula. Lets assume, according to formula in
cell A1, the value is "Yes" in cell A1. Now if I change the value in cell A1
to "" (blank space) manually, the formula will get erased. Is there a way
around this, that cell keeps its formula?

Thank you
-Hina

Obviously, if you replace the contents of the cell ...

But maybe you want something like:

A1: =IF(test_condition,"Yes","")

--ron

 

[Hina]

Na, that is the problem. Maybe there's a better solution to this. Lets say
you have a column B which represents Date issued of a Waiver. Now you also
have formula associated to that column. If you type in " 10 Sep" in B1, the
value in C1 should be "Waive issued".

Now lets say I made a mistake in typying the date. I want to go back and
change the date to 12 sep. If I hit delete for cell B1 so I can type in "12
sep" instead, the formula gets erased.
That is the problem. I dont want the formula to get erased.

Any ideas?
argh I just hate creating macros, and don't want to make this complicated.

 

[Hina]

Na, that is the problem. Maybe there's a better solution to this. Lets say
you have a column B which represents Date issued of a Waiver. Now you also
have formula associated to that column. If you type in " 10 Sep" in B1, the
value in C1 should be "Waive issued".

Now lets say I made a mistake in typing the date. I want to go back and
change the date to 12 sep. If I hit delete for cell B1 so I can type in "12
sep" instead, the formula gets erased.
That is the problem. I dont want the formula to get erased.

Any ideas?
argh I just hate creating macros, and don't want to make this complicated.

 

[Hina]

Ahh okay.. I figured it out. Having the formula in C1 instead of B1 works!

 

[Ron Rosenfeld]

Ahh okay.. I figured it out. Having the formula in C1 instead of B1 works!

Exactly!
--ron