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

How do I write an IF formula that's not case sensitive?

Latest post Thu, Sep 25 2014 12:15 PM by PeterG. 1 replies.
  • Thu, Sep 25 2014 7:47 AM

    • George3578
    • Top 500 Contributor
    • Joined on Fri, Sep 5 2014
    • Posts 5
    • Points 89

    How do I write an IF formula that's not case sensitive?

    I am trying to get an IF formula thats not case sensitive but I cant seem to do it write...please help. 

    • Post Points: 21
  • Thu, Sep 25 2014 12:15 PM In reply to

    • PeterG
    • Top 10 Contributor
    • Joined on Mon, Feb 25 2008
    • Posts 224
    • Points 3,368

    Re: How do I write an IF formula that's not case sensitive?

    You need to provide more detail.

    If you test for the equality of two strings with a formula such as ="a"="A",you will see that Excel treats these two strings in a case insensitive manner and returns a value of TRUE.

    Peter

    • 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.