+ Reply to Thread
Results 1 to 8 of 8

Logical operators: equal to, not equal to

  1. #1
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Logical operators: equal to, not equal to

    Hello Everyone

    i dont know what "<>"& "="& means in the following formula as a criteria
    i know = and <> , but i dont know what does & means in this place, also i dont know whats the quotatios do ""

    =IF(ISBLANK(U3447),"",COUNTIFS(F:F,F3447,Z:Z,Z3447,D:D,"<>"&D3447))+IF(ISBLANK(U3447),"",COUNTIFS(F:F,F3447,Z:Z,Z3447,D:D,"="&D3447))
    Last edited by Mahmoudelnemr; 11-19-2019 at 09:14 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,414

    Re: "<>"& "="&

    Administrative Note:

    We would very much like to help you with your query, however the thread title does not really convey what your request is about.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Re: "<>"& "="&

    Dear AliGW,

    Good day, i hope the title now meets the forum rules

  4. #4
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: Logical operators: equal to, not equal to

    Double quotes are text delimiters
    "2" is text while 2 is a number
    the & is used to concatenate text strings "<>"&5 is the same as <>5

  5. #5
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Re: Logical operators: equal to, not equal to

    Hello Pepe, thx for ur reply
    so, both the following formulas work the same ?

    COUNTIF(D:D,"<>"&D3447)
    COUNTIF(D:D,<>D3447)

  6. #6
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,445

    Re: Logical operators: equal to, not equal to

    Yes but the syntax defined by XL needs the "<>" part
    (BTW using entire column references is not a good idea)

  7. #7
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.84 for Mac MS 365
    Posts
    8,496

    Re: Logical operators: equal to, not equal to

    COUNTIFS(F:F,F3447,Z:Z,Z3447,D:D,"<>"&D3447))
    this is saying not equal to D3447.
    COUNTIFS(F:F,F3447,Z:Z,Z3447,D:D,"="&D3447))
    this is saying equal to D3447 and can be written this way... COUNTIFS(F:F,F3447,Z:Z,Z3447,D:D,D3447))
    without the "="& part.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  8. #8
    Forum Contributor
    Join Date
    05-14-2019
    Location
    Alex, Egypt
    MS-Off Ver
    365
    Posts
    254

    Re: Logical operators: equal to, not equal to

    Thanks a lot

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  2. Replies: 2
    Last Post: 07-24-2017, 02:19 AM
  3. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  4. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  5. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  6. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  7. Replies: 7
    Last Post: 05-13-2006, 05:02 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1