Consulting

Results 1 to 4 of 4

Thread: Fine tuning an If formula. Cells matching based on Condition

  1. #1

    Fine tuning an If formula. Cells matching based on Condition

    Using the formula:
    =IF(J9<>"x","",IF(AND(J6=J10,J9="x"),TRUE,IF(AND(J6<>J10,J9="x"),".")))

    Is there a way to change it so that if cell J10 is blank then it shows "" but if there is something in J10 then "." when it does not match J6?

    Example from picture:
    J11 shows True because J10 and J6 match each other.
    M11 shows "." because M10 and M6 do not match each other.
    L11 shows "." but cell L10 is blank. I want it to show "" when cell L10 is blank.

    I need the change that is in bold.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    =IF(OR(J9<>"x",J10=""),"",IF(AND(J6=J10,J9="x"),TRUE,IF(AND(J6<>J10,J9="x") ,".")))
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

  3. #3
    Perfect!

  4. #4
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    Actually, be careful, it may not be, it all depends upon order priority.

    In your example, if J9 were blank, it would return blank. Is this what you want, or should it be TRUE?
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

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