I want the value of a cell to be 0 if the corresponding cell in the Material column is not blank or if the corresponding cell in the Item Category column is not D or L, otherwise it should return a 1. All the other cells referenced are formatted as text even if there is a number in the Material column. The cells where the formula is at are formatted as a whole number.
I fixed the #NAME? error I had initially, but now I have tried the following formulas and I am getting all 0's in each, even if the outcome is false...
=IF(OR((NOT(ISBLANK([@Material]))), OR([@[Item Category]]="L",[@[Item Category]]="D")),0,1)
=IF(AND(ISBLANK([@Material]),OR([@[Item Category]]<>"D",[@[Item Category]]<>"L")),1,0)
=IF(OR(((ISBLANK([@Material]))), [@[Item Category]]="L",[@[Item Category]]="D"),0,IF(NOT(ISBLANK([@Material])),0,1))
There was another formula that returned all 1's but I forgot to copy it before changing it. Maybe I am just tired, but I can't seem to find the issue. Any ideas would be greatly appreciated!!
I fixed the #NAME? error I had initially, but now I have tried the following formulas and I am getting all 0's in each, even if the outcome is false...
=IF(OR((NOT(ISBLANK([@Material]))), OR([@[Item Category]]="L",[@[Item Category]]="D")),0,1)
=IF(AND(ISBLANK([@Material]),OR([@[Item Category]]<>"D",[@[Item Category]]<>"L")),1,0)
=IF(OR(((ISBLANK([@Material]))), [@[Item Category]]="L",[@[Item Category]]="D"),0,IF(NOT(ISBLANK([@Material])),0,1))
There was another formula that returned all 1's but I forgot to copy it before changing it. Maybe I am just tired, but I can't seem to find the issue. Any ideas would be greatly appreciated!!