GJLind2002
New Member
- Joined
- Dec 2, 2016
- Messages
- 4
I want column C to say CLOSED when Columns A & B both say COMPLETE
I tried =if(a2=b2, CLOSED) but that gives me results whenever A & B match (including when they are both blank). I only want results when A & B say COMPLETE. What am I leaving off the formula?
Thanks
I tried =if(a2=b2, CLOSED) but that gives me results whenever A & B match (including when they are both blank). I only want results when A & B say COMPLETE. What am I leaving off the formula?
Thanks