Forum Discussion
Solved
Need Nested IF Formula to Count Data Only, Not Formulas
Hello, I cannot figure out how to get my formula to account for data returned from another cell, not it's formula. I'll attempt to explain simply, I have sets of 5 water samples per fixture t...
First, apply to the column General format instead of Text. Formula is like
=IF(AND(Y2=0,Z2<>0),"YELLOW",IF(AND(Y2<>0,Z2=0),"RED",IF(AND(Y2<>0,Z2<>0),"BOTH","NEITHER")))
tauqeeracma I forgot to change it back but I changed the sheet to leave a cell blank if the result was "0", and I still had the same problem.
First, apply to the column General format instead of Text. Formula is like
=IF(AND(Y2=0,Z2<>0),"YELLOW",IF(AND(Y2<>0,Z2=0),"RED",IF(AND(Y2<>0,Z2<>0),"BOTH","NEITHER")))
SergeiBaklan Okay, I had it that way before and still the same issue, I was just changing up formatting types to see if it made a difference and it doesn't. Still the same problem.
tauqeeracma Attached is a sample set! The only difference is the results column is now column Q
