Nested IF formula - problem

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:

Please Login or Register  to view this content.

Thanks for your help all!

Originally Posted by arthurbr

So if both values are >0 print W and if they are both <0 what should be printed?
What is the result if none of these conditions is met?

Same if they are both negative, print a W. if the first is a negative but the second is not, then print a L.

I'm not sure what you mean by "if none of these conditions is met" could you please explain a little further?

Thanks!

edit: I think I know what you mean now, if none of the conditions are met, that is if any of the cells has a 0 instead of a positive or negative number, then print a "P" instead of a "W" or an "L"

Thanks!