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 Attached is a sample set! The only difference is the results column is now column Q