Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Similiar to Blank Formula Fields

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a somewhat similiar problem.
    I have this formula in N12 =IF(J12=K12,1,0)

    If J12 and K12 are equal AND have numbers in them, all is fine. But if J12 and K12 are blank, it still returns the value 1.

    What I want is, if J12 and K12 are blank ... to return the value 0 ... or ... nothing.

    Would appreciate the help.
    Excel Newbie


  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,024
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-03-17 16:15, notion54 wrote:
    I have a somewhat similiar problem.
    I have this formula in N12 =IF(J12=K12,1,0)

    If J12 and K12 are equal AND have numbers in them, all is fine. But if J12 and K12 are blank, it still returns the value 1.

    What I want is, if J12 and K12 are blank ... to return the value 0 ... or ... nothing.

    Would appreciate the help.
    Excel Newbie
    =ISNUMBER(J12)*(ISNUMBER(K12)*(J12=K12)

    will do what you want.


  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Wow ... I am impressed ... tried to figure that out for 3 hours. 3 minutes here did the trick ... that worked perfectly.

    Thankyou

    On 2002-03-17 16:19, Aladin Akyurek wrote:
    =ISNUMBER(J12)*(ISNUMBER(K12)*(J12=K12)

    will do what you want.


Some videos you may like

User Tag List

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
  •