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")))
SergeiBaklan Oh! I'm sorry I didn't see you had actually adjusted the formula and not the column formatting. Yes, that solved the problem thank you so much!!!
stamez , you are welcome