Enter Text

AllenL · Mar 21st, 2002, 01:38 PM

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 · Mar 21st, 2002, 01:50 PM

Oh I figured out how to solve this problem now

Mark O'Brien · Mar 21st, 2002, 01:51 PM

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 · Mar 21st, 2002, 02:05 PM

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

Mar 21st, 2002, 01:51 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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 __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 01:38 PM	#1
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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

Mar 21st, 2002, 01:50 PM	#2
AllenL Board Regular Join Date: Mar 2002 Posts: 67	Oh I figured out how to solve this problem now

Mar 21st, 2002, 02:05 PM	#4
AllenL Board Regular Join Date: Mar 2002 Posts: 67	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