Tenoreprimo
New member
- Joined
- Mar 14, 2013
- Messages
- 2
- Reaction score
- 0
- Points
- 0
I'm not a power user, and I have what seems to be a simple problem. I have 2 numerical cells, A1 and A2. I need to enter either "Good" or "Not Good" in cell A3. If A1 is more than 4, AND A2 is less than 4, the cells are "Good." Otherwise they are "Not Good."
I tried the formula: =IF(AND(A1>4,A2<4),"Good","Not Good")
It does not seem to evaluate properly. What am I doing wrong?
I tried the formula: =IF(AND(A1>4,A2<4),"Good","Not Good")
It does not seem to evaluate properly. What am I doing wrong?