and a condition inside a long nest if that has multiple criteria.

I have a number in this inside this formula t


the formula is producing a "8020" results because the #002534 falls within the criteria.

I need to somehow make it so ONLY 002534 does not produce anything, but the rest of the range numbers are fine. I just need to somehow add a another condition to take #002534 out.

Please Login or Register  to view this content.

I then need to add that #002534 to another cell formula below.

Please Login or Register  to view this content.

If you need to exclude 002534 from the first formula entirely, then just add it as another condition to your last AND() function, W1622<>"002534"

It should already be added into your second formula because it is not in the list of things to exclude, unless it should be included when "Juice" is found in G5, in which case you need an OR condition.

Is this linked to your other thread with regard to condensing 4 formulas into 1?

The formulas that you have inherited are a bit messy to say the least, maybe best to reslove one issue at a time and clean it up before changing it.

In addition to the above, one other thoughtt.

Would the list of things to be included be shorter than the current list of those to exclude?

Things to include are more manageable than things to exclude, more so if you still want to try and condense 4 formulas into one with your other thread.

Try using the approach suggested there with lists of things to include / exclude, which, in my opinion would be preferrable to the long formulas that you have at the moment.

@Ford, maybe worth combining with this thread, https://www.excelforum.com/excel-for...statement.html

while not a duplicate, the solutions could be most likely combined.

@JASON.B75, thanks this did the trick I have that same formula for other columns as well. I will work on migrating those numbers into a list range to reduce down the massive conditions on this formula. I took over this from someone else, so just trying to simplify the formulas.

then just add it as another condition to your last AND() function, W1622<>"002534"