montanaaggie
Board Regular
- Joined
- Nov 11, 2005
- Messages
- 122
- Office Version
- 365
- Platform
- Windows
I have an equation in column J where I'd like it to tell me if there is a value in column F, but not in column G, to put an X. I used the following formula but its not working:
=IF(AND(F3<>"",G3=""),"X","")
=IF(AND(F3<>"",G3=""),"X","")