<div>
@Rgonzo<br />
Good catch. Thanks for the information. :)
</div>


<div>
WOW Rgonzo<br />
<br />
I am really impressed.
</div>


<div>
Tweaked formula.....<br />
<br />

<pre><code id="code-20-41831560-1">=IF(ISNUMBER(MATCH(A2&amp;&quot; &quot;&amp;B2,{&quot;1 9&quot;,&quot;2 12&quot;,&quot;3 18&quot;,&quot;4 15&quot;,&quot;5 22&quot;,&quot;6 95&quot;,&quot;12 19&quot;,&quot;42 52&quot;},0)),&quot;&quot;,&quot;OK&quot;)</code></pre>
</div>


<div>
<div class="content wysiwyg-content">
i have this long formula.<br />
<br />
=IF(OR(AND(A2=1,B2=9),AND(<wbr />A2=2,B2=12<wbr />),AND(A2=3<wbr />,B2=18),AN<wbr />D(A2=4,B2=<wbr />15),AND(A2<wbr />=5,B2=22),<wbr />AND(A2=6,B<wbr />2=95),AND(<wbr />A2=12,B2=1<wbr />9),AND(A2=<wbr />42,B2=52))<wbr />,&quot;&quot;,&quot;Ok&quot;)<br />
<br />
is there any easy way or more simplistic way to achieve the same without these too many ORs and ANDs ? or make it work in a better way.
</div>
</div>


i have this long formula.

=IF(OR(AND(A2=1,B2=9),AND(A2=2,B2=12),AND(A2=3,B2=18),AND(A2=4,B2=15),AND(A2=5,B2=22),AND(A2=6,B2=95),AND(A2=12,B2=19),AND(A2=42,B2=52)),"","Ok")

is there any easy way or more simplistic way to achieve the same without these too many ORs and ANDs ? or make it work in a better way.

@Rgonzo
Good catch. Thanks for the information. :)

how to simplify this IF OR AND functions

i have this long formula.

=IF(OR(AND(A2=1,B2=9),AND(A2=2,B2=12),AND(A2=3,B2=18),AND(A2=4,B2=15),AND(A2=5,B2=22),AND(A2=6,B2=95),AND(A2=12,B2=19),AND(A2=42,B2=52)),&quot;&quot;,&quot;Ok&quot;)

is there any easy way or more simplistic way to achieve the same without these too many ORs and ANDs ? or make it work in a better way.

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