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
=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