<div>
I think this should do...<br />
<br />
=IF(AND(AK2=&quot;&quot;,AL2=&quot;&quot;),&quot;&quot;,<wbr />IF(AK=AL2,<wbr />&quot;Same&quot;,&quot;Mi<wbr />xed&quot;))
</div>


I think this should do...

=IF(AND(AK2="",AL2=""),"",IF(AK=AL2,"Same","Mixed"))

<div>
Try this<br />
<br />
=IF(AND(AK2=&quot;John&quot;,AL2=&quot;Jo<wbr />hn&quot;),&quot;Same<wbr />&quot;,IF(AND(A<wbr />K2=&quot;&quot;,AL2=<wbr />&quot;&quot;),&quot;Both Blank&quot;,&quot;&quot;))
</div>


Try this

=IF(AND(AK2="John",AL2="John"),"Same",IF(AND(AK2="",AL2=""),"Both Blank",""))

<div>
<div class="content wysiwyg-content">
In Excel I use this IF formula to determine a comparison of two adjacent cells first to see if they are blank and second to see if they are the same value (but not blank)<br />
I have this array formula which almost works.<br />
=IF(OR(AK2=&quot;&quot;,AL2=&quot;&quot;),&quot;Bot<wbr />hBlank&quot;,IF<wbr />(AK2=AL2,&quot;<wbr />Same&quot;,AK2=<wbr />AL2))<br />
<br />
I am not permitted to change the data so I am looking to see if cells are blank (vs 0) and if not blank are they the same.<br />
example<br />
AK2= John &nbsp;AL2=John &nbsp;should return &quot;Same&quot;<br />
AK2= &quot;&quot;&nbsp;AL2= &quot;&quot;&nbsp;should return BothBlank<br />
&nbsp;however if there is one cell blank and the other one has value it still says both blank.<br />
I think I need to add another argument to return &quot;Mixed&quot; if AK2 &lt;&gt;AL2 however I cant seem to get it right. &nbsp;I believe that &lt;&gt;&nbsp;is excels version of &quot;does not equal&quot;.
</div>
</div>


In Excel I use this IF formula to determine a comparison of two adjacent cells first to see if they are blank and second to see if they are the same value (but not blank)
I have this array formula which almost works.
=IF(OR(AK2="",AL2=""),"BothBlank",IF(AK2=AL2,"Same",AK2=AL2))

I am not permitted to change the data so I am looking to see if cells are blank (vs 0) and if not blank are they the same.
example
AK2= John  AL2=John  should return "Same"
AK2= "" AL2= "" should return BothBlank
 however if there is one cell blank and the other one has value it still says both blank.
I think I need to add another argument to return "Mixed" if AK2 <>AL2 however I cant seem to get it right.  I believe that <> is excels version of "does not equal".

formula for reporting blanks and matches in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.