Compare text using if function in Excel 2007

I have two cells and wish to dislpay diferent text in onem dependant upon the text in the other. Cell A1 usually has “result” dosplayed and cell A2 “lost/WON. If “WON” is typed into cell A1, I wish A2 to display “WON”. If anything else is typed into cell A1, I wish cell A2 to display “lost”. The following formula does not appear to be accepted: =IF(A1=”result”,”lost/WON”,if(A1=”WON”,”WON”,”lost”)).

By: John Banwell

18 thoughts on “Compare text using if function in Excel 2007

  1. sling tv

    Magnificent items from you, man. I’ve be aware your stuff prior to and you’re just too
    excellent. I really like what you’ve acquired here,
    certainly like what you are stating and the way through which you
    are saying it. You’re making it enjoyable and you
    still take care of to stay it sensible. I can’t wait to read much more from you.

    That is actually a great web site.

  2. sling tv

    I have read some excellent stuff here. Definitely value
    bookmarking for revisiting. I wonder how a lot effort you set to make any such magnificent informative web site.

  3. match.com free trial

    Hello would you mind letting me know which hosting company you’re working with?

    I’ve loaded your blog in 3 completely different browsers and I must say this
    blog loads a lot faster then most. Can you suggest a good internet hosting provider at a honest price?

    Thanks, I appreciate it!

  4. ps4 games

    Unquestionably imagine that which you stated. Your favourite reason appeared to be on the web the
    simplest thing to take into account of. I say to you,
    I certainly get irked while folks think about issues that they plainly don’t understand about.
    You controlled to hit the nail upon the top and defined out the entire thing with no need side-effects , people can take
    a signal. Will probably be back to get more. Thank you

  5. Maureen Dion

    There are some interesting points in time in this article but I don?t know if I see all of them center to heart. There is some validity but I will take hold opinion until I look into it further. Good article , thanks and we want more! Added to FeedBurner as well

  6. quest bars cheap

    Generally I don’t read article on blogs, however I would like to say that this
    write-up very pressured me to try and do so! Your writing style has been surprised me.
    Thank you, very nice article.

  7. ps4 games

    What’s up to every body, it’s my first pay a quick visit of this
    web site; this website consists of amazing
    and really good material in favor of visitors.

  8. quest bars cheap

    Hmm is anyone else experiencing problems with the
    pictures on this blog loading? I’m trying to determine if its a problem on my end
    or if it’s the blog. Any feed-back would be greatly appreciated.

  9. tinyurl.com

    Fantastic beat ! I would like to apprentice even as you amend your website,
    how could i subscribe for a blog site? The account helped
    me a applicable deal. I had been tiny bit acquainted of this your
    broadcast provided brilliant transparent concept

Comments are closed.