Cell formula functions correctly in one workbook but doesn't not function correctly in another

[Brock_Hardchest]

Hello,

I have two identical workbooks, one I i saved a month ago and has a correctly functioning formula and the other I am using today with same formula that does not function correctly. The only difference is the number in column M. The logic for the formula in cell S8 should produce M8*N8 which it does in the workbook from last month but produces "-" today. I even copied and pasted the formula back and forth to make sure they are identical. Any ideas? Stumped on this.

The formula in S8 is:

=IF(AND(G8="Monthly Minimum",SUMIFS(R:R,B:B,B8,I:I,"<>N/A")<H8),H8,IF(AND(G8<>"Monthly Minimum",SUMIFS(R:R,B:B,B8,I:I,"<>N/A")<H8,OR(I8="N",I8="Y")),0,IF(AND(G8="Tier Price",L8="Achieved"),N8,IF(OR(AND(I8="N",L8="Y"),AND(G8="Tier Price",I8="N/A",L8="Y")),0,IF(OR(AND(I8="N",L8="N"),I8="Y",AND(G8<>"Tier Price",I8="N/A")),M8*N8,0)))))

 

[RoryA]

Can't see all of your data, but presumably one of your criteria that return 0 is being met. Possibly the second one, though I can't be sure of what your SUMIFS is returning.