Results 1 to 7 of 7

Nested IF statement to return a value based on multiple criteria

Threaded View

harrydnyc Nested IF statement to return... 07-13-2011, 10:44 AM
alansidman Re: Nested IF statement to... 07-13-2011, 11:25 AM
ConneXionLost Re: Nested IF statement to... 07-13-2011, 11:37 AM
harrydnyc Re: Nested IF statement to... 07-13-2011, 01:31 PM
ConneXionLost Re: Nested IF statement to... 07-15-2011, 03:32 PM
azb0105 Re: Nested IF statement to... 07-27-2011, 05:05 AM
ConneXionLost Re: Nested IF statement to... 07-27-2011, 11:45 AM
  1. #1
    Registered User
    Join Date
    04-08-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2007
    Posts
    30

    Nested IF statement to return a value based on multiple criteria

    Hello Excel Gurus,

    I am trying to return a value based on multiple criteria using a nested IF statement. Basically, I have a table that contains costs for a direct mail campaign, and I am trying to return the cost of the program based on the values that can be selected in two separate cells which both have drop-down lists. There are 20 different possible values that can be returned based on the possible combination of selections in those two separate cells.

    If you look at the attached spreadsheet, the cell that I am trying to return the costs to is cell B4 (Total Program Costs). The possible values that can be returned are all in column G.

    The statement should return values based on two criteria:

    1) It should compare the value of B2 with the values in Row F
    2) It should also compare the value of B3 and compare with the values in Row A.

    It should then return the value based on the way the table is set up.

    So, if a user selects "Long Mailer" in cell B3, and 100,000 in B2, then cell B4 should return a value of $43,300.

    If a user selects "Jumbo Postcard" in cell B3, and 25,000 in B2, then cell B4 should return a value of $11,500.

    I attempted to solve the problem using a really long nested IF statement using the AND command as well. I got an error message in Excel telling me that I had exceeded the max amount of levels in a nested statement. I am assuming there is a more elegant way to do this, but I cannot figure it out.

    Help!

    Thanks.
    Attached Files Attached Files

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