Results 1 to 12 of 12

Multiple criteria if statement

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2011
    Location
    Midd, New Jersey
    MS-Off Ver
    Excel 2010
    Posts
    4

    Question Multiple criteria if statement

    I have microsoft excel 2010. I need help writing a formula/function for column AA. Here's what I want it to do in English:

    If P3 = “True”, than V3 needs to be >= (greater than or equal to) 40% of H3. If it is, I want success to appear in column AA. If it’s not, I want fail to appear in column AA.

    If Q3 is “True”, than V3 needs to be >= (greater than or equal to) 60% of H3. If it is, I want success to appear in column AA. If it’s not, I want fail to appear in column AA.

    If R3 is “True”, than V3 needs to be >= (greater than or equal to) H3. If it is, I want success to appear in column AA. If it’s not, I want fail to appear in column AA.

    If S3 is “True”, than V3 needs to be >= (greater than or equal to) H3. If it is, I want success to appear in column AA. If it’s not, I want fail to appear in column AA.

    If there is a way to get this all in one function, I'd appreciate that very much. Here's an example:

    P3 says True (which means Q,R,and S cannot be true and must be false). V3 is just the number 28 and H3 is just the number 10. Obviously, 40% of 10 is 6 and 28>6. So, in column AA, I would like it to say "Success".

    Thank you very much. I appreciate it!
    Last edited by marlin5124; 07-10-2011 at 07:57 PM. Reason: Better Title

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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