Re: One more IF - dont know where to put it
ok, just to confirm I'm following your logic - is this what you would expect formula in J2 on the Home tab to return:
and this is for K2:
Would definitely go with this, array formulas are unstable and take longer to calculate (which might not be the issue here, just something to consider).
Are you looking to update the whole sheet of formulas for this?