Exact function
Results 1 to 6 of 6

Thread: Exact function

  1. #1
    New Member
    Join Date
    Aug 2014
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Exact function

    I am trying to compare A to B cell with exact function. The problem is when there are two empty cells it returns me TRUE. I would like to return me number 0.

    Thank you in advance

  2. #2
    Board Regular Michael M's Avatar
    Join Date
    Oct 2005
    Location
    South Western NSW
    Posts
    17,503
    Post Thanks / Like
    Mentioned
    18 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Exact function

    Try

    Code:
    =IF(EXACT(A1,B1),0,FALSE)
    Regards
    Michael M
    ---------------------------------------
    The more I learn, the less I seem to know.....A Please and Thank You cost nothing !
    It's easier to debug if we can see the whole macro !
    Home 2007 & 2013

    - Posting guidelines, forum rules and terms of use

    - To download Mr Excel HTML Maker

    - Try searching for your answer first, see how

    - Read the FAQs

    - List of BB codes


    [CODE]Place Your Code Here[/CODE]

  3. #3
    New Member
    Join Date
    Aug 2014
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Exact function

    I would just like to return me 0 when there are two empty cells, otherwise when there is lets say 5:5 or 10:10 then I would like to return me TRUE
    Last edited by Greenlee; Jul 16th, 2019 at 10:39 PM.

  4. #4
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,146
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Exact function

    Hi,

    Is this what you mean:

    ABC
    155TRUE
    26FALSE
    31010TRUE
    47FALSE
    50
    656FALSE

    Sheet689



    Worksheet Formulas
    CellFormula
    C1=IF(AND(A1="",B1=""),0,EXACT(A1,B1))


  5. #5
    New Member
    Join Date
    Aug 2014
    Posts
    23
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Exact function

    Quote Originally Posted by jtakw View Post
    Hi,

    Is this what you mean:

    A B C
    1 5 5 TRUE
    2 6 FALSE
    3 10 10 TRUE
    4 7 FALSE
    5 0
    6 5 6 FALSE
    Sheet689

    Worksheet Formulas
    Cell Formula
    C1 =IF(AND(A1="",B1=""),0,EXACT(A1,B1))
    Yes, Thank you very much!

  6. #6
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,146
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Exact function

    You're welcome, thanks for the feedback.

Some videos you may like

User Tag List

Tags for this Thread

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
  •