Enter Text

[AllenL]

Question:
I am trying to enter a text "property" beside a text "Freq."
So I enter the formula in cell b1
=if(a1="Freq.", "property",)
But it changes all my other cells which don't have "Freq." beside them to "False".
I can't change the values of those cells
How would you solve this problem???
Thanks in advance

 

[AllenL]

Oh I figured out how to solve this problem now

 

[Mark O'Brien]

Off the top of my head, it doesn't look as though you're telling Excel what to put in if the result of the IF statement is false, try this formula instead:

=if(a1="Freq.", "property","")

HTH

 

[AllenL]

Yes, I tried that one as well. However, it just erases all the text that does't enter the text "Property"
So what I did was that I creat a new column
ie column B. and the old column B becomes column C
in cell B1 I enter
=if(a1="Freq.","Property",c1)
and it works. Then I just delete column C
Anyways, Thanks Mark for trying to help