Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

NEED HELP WITH THE 'IF' FUNCTION AGAIN

Latest post Mon, Feb 9 2015 9:20 AM by coleburdette. 1 replies.
  • Mon, Feb 9 2015 8:25 AM

    • stephcowie
    • Not Ranked
    • Joined on Thu, Feb 5 2015
    • Posts 2
    • Points 42

    NEED HELP WITH THE 'IF' FUNCTION AGAIN

    hey Guys,

     

    Still trying to work out how to use this properly. Thanks so much for the help on the last post!!!!

     

    I need help again with the IF function.

     

    Is this possible to do......

     

    I have a cell which contains text

     

    Cell B1 = 1SSXTEDPLRP, what i am trying to do is say that if cell B1=1SSXTEDPLRP, cell C1=1

     

    Is this possible with text?

    Thanks again for all the help!!!!!

    • Post Points: 21
  • Mon, Feb 9 2015 9:20 AM In reply to

    Re: NEED HELP WITH THE 'IF' FUNCTION AGAIN

    you have to use quotes around text.

    In cell C1 put this formula.  Not sure what you want to show if it is not true but I put 0.

    =if(B1="1SSXTEDPLRP",1,0)

    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.