Nested if or function

[drluke]

I have a nested IF OR formula, but both of the criteria to evaluate has the same result. My formula is:

=IF(OR($A$4<>"D",$A$4=$D$3),IF(INDEX(DATA!$A$11:$P$89,MATCH($A76,DATA!$A$11:$A$89,0),1)=$A76,OFFSET(DATA!$P80,0, (-DATA!$P$8)),"Error"),IF(INDEX(DATA!$A$11:$P$89,MATCH($A76,DATA!$A$11:$A$89,0),1)=$A76,OFFSET(DATA!$P80,0,(-DATA!$P$8)) ,"Error")) <colgroup><col width="64" style="width: 48pt;"> <col width="76" style="width: 57pt; mso-width-source: userset; mso-width-alt: 2779;"> <col width="62" style="width: 47pt; mso-width-source: userset; mso-width-alt: 2267;"> <col width="64" style="width: 48pt;" span="2"> <col width="77" style="width: 58pt; mso-width-source: userset; mso-width-alt: 2816;"> <col width="64" style="width: 48pt;" span="3"> <col width="55" style="width: 41pt; mso-width-source: userset; mso-width-alt: 2011;"> <col width="64" style="width: 48pt;"> <col width="101" style="width: 76pt; mso-width-source: userset; mso-width-alt: 3693;"> <col width="64" style="width: 48pt;" span="6"> <col width="152" style="width: 114pt; mso-width-source: userset; mso-width-alt: 5558;"> <col width="64" style="width: 48pt;" span="2"> <tbody> </tbody> The formula works ok, but as both options for A4 has the same result, is there a way I can shorten this formula and make it less complex?

<colgroup><col width="64" style="width: 48pt;"> <tbody> </tbody>

 

[jtakw]

Hi,

You don't need the duplicated 2nd half of the formula, try it like this:

=IF(OR($A$4<>"D",$A$4=$D$3),IF(INDEX(DATA!$A$11:$P$89,MATCH($A76,DATA!$A$11:$A$89,0),1)=$A76,OFFSET(DATA!$P80,0,(-DATA!$P$8)),"Error"),"Error")

 

[sami1]

good solution