Results 1 to 10 of 10

Nested IF formula - problem

Threaded View

  1. #1
    Registered User
    Join Date
    04-03-2008
    Posts
    14

    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:

    =IF((AND(Q41>0,X41>0)),"W","L")
    Thanks for your help all!
    Last edited by DUAL; 11-26-2008 at 04:15 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1