Formula help.

[Ian Betteridge]

Evening all,
I've got a formula that I need to change...
=IF(A2="","",IF(B2>102,"",IF(F2="","",IF(SUMPRODUCT(--($C$2:$C$5001=$C2)*--($F$2:$F$5001<=(F2+0.5/24))*--($F$2:$F$5001>=(F2-0.5/24)))>1,"Check Order",""))))

The 102 is data extracted from SAP and is actually text not number.
I want the above formula but I need it to return "" if cell B2 is either 101 or 102 (text)

Thanks Ian

 

[Ian Betteridge]

Should be...

Evening all,
I've got a formula that I need to change...
=IF(A2="","",IF(B2>102,"",IF(F2="","",IF(SUMPRODUCT(--($C$2:$C$5001=$C2)*--($F$2:$F$5001<=(F2+0.5/24))*--($F$2:$F$5001>=(F2-0.5/24)))>1,"Check Order",""))))

The 102 is data extracted from SAP and is actually text not number.
I want the above formula but I need it to return "" if cell B2 is neither 101 or 102 (text)

Thanks Ian