TO summarize, I am trying to compare numbers in 2 columns (Q and X). If the first number (Q) is positive, I want to compare it to the second number (X) to see if it is also positive. If the second number (X) is also positive, then I want to print "W", otherwise I want to print "L".
I want to do the same with a negative number in column Q and see if column X is also negative, but that is where I am running into problems - nesting a second IF statement that will accomplish that. I have tried to do it a number of ways, and have encountered errors each time.
Here is what I have so far, very simple as you can see:
=IF((AND(Q41>0,X41>0)),"W","L")
Thanks for your help all!
Bookmarks