Enter Text
Prep for a pre-employment Excel test with Job Test Prep
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Enter Text

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Oh I figured out how to solve this problem now

  3. #3
    MrExcel MVP Mark O'Brien's Avatar
    Join Date
    Feb 2002
    Location
    Columbus, OH, USA
    Posts
    3,530
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Posts
    67
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com