+ Reply to Thread
Results 1 to 2 of 2

Complex IF / THEN formula

  1. #1
    Registered User
    Join Date
    08-08-2013
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    2

    Complex IF / THEN formula

    Hello,

    I need assistance in writing a formula that does the following:

    If the value I enter into cell R3 is the same as just cell A3, then cell U3 needs to populate with the data in cell B3 OR if R3 AND S3 = E3 AND F3 then U3 = H3.

    Also, this not for just cell R3, I'll be filling in several rows within R. Up to 481 rows.
    Lastly, all information noted above is already loaded in the same spreadsheet (with the exception of what I will be entering in to column R).


    Thank you !!!!

  2. #2
    Registered User
    Join Date
    08-08-2013
    Location
    Frankfurt, Germany
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Help writing a formula

    Hi

    this formula to be entered in cell U3 may work:

    =IF(R3=A3,B3,IF(AND(R3=E3,S3=E3),H3,""))

    If non of the conditions is fulfilled a blank cell will be returned.

    J

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. More complex look up formula
    By burnsie in forum Excel General
    Replies: 2
    Last Post: 03-11-2013, 06:26 AM
  2. complex formula?
    By spinkung in forum Excel General
    Replies: 1
    Last Post: 12-22-2009, 05:20 AM
  3. Complex Sum formula
    By hartski in forum Excel General
    Replies: 2
    Last Post: 11-19-2008, 12:08 PM
  4. Can someone help with this complex formula?
    By My2Boyz9802 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-21-2006, 12:12 PM
  5. Complex formula
    By Marc in forum Excel General
    Replies: 8
    Last Post: 10-19-2005, 10:05 PM

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