I think the max nested if is seven and it really gets harry, even at seven.
Still not clear what your final objective is here? You want to simply see if
you have something in stock, based on 7-10 criteria?

Thanks,

"Jimc" wrote:

Looking for tips/tricks for the following scenario - Need ot be able to if
then through approx 7-10 pieces of criteria and then present result - any
suggestions greatly appreciated