PDA

View Full Version : Fine tuning an If formula. Cells matching based on Condition



Alphacsulb
03-26-2008, 09:36 AM
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. http://www.mrexcel.com/forum/images/smilies/icon_smile.gif
M11 shows "." because M10 and M6 do not match each other. http://www.mrexcel.com/forum/images/smilies/icon_smile.gif
L11 shows "." but cell L10 is blank. I want it to show "" when cell L10 is blank. http://www.mrexcel.com/forum/images/smilies/frown.gif

I need the change that is in bold.
http://i88.photobucket.com/albums/k193/Rgarcia9/97fc4479.jpg

Bob Phillips
03-26-2008, 09:44 AM
=IF(OR(J9<>"x",J10=""),"",IF(AND(J6=J10,J9="x"),TRUE,IF(AND(J6<>J10,J9="x"),".")))

Alphacsulb
03-26-2008, 09:52 AM
Perfect!

Bob Phillips
03-26-2008, 09:54 AM
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?