Results 1 to 10 of 10

using INDEX and IF to output value meeting multiple min/max range constraints

Threaded View

myersac using INDEX and IF to output... 04-30-2013, 03:29 PM
AndyLitch Re: using INDEX and IF to... 04-30-2013, 03:41 PM
myersac Re: using INDEX and IF to... 04-30-2013, 03:43 PM
Lemice Re: using INDEX and IF to... 04-30-2013, 03:48 PM
myersac Re: using INDEX and IF to... 04-30-2013, 03:59 PM
Pete_UK Re: using INDEX and IF to... 04-30-2013, 03:48 PM
Harribone Re: using INDEX and IF to... 04-30-2013, 03:53 PM
Lemice Re: using INDEX and IF to... 04-30-2013, 04:06 PM
myersac Re: using INDEX and IF to... 04-30-2013, 04:13 PM
myersac Re: using INDEX and IF to... 04-30-2013, 04:09 PM
  1. #1
    Registered User
    Join Date
    04-30-2013
    Location
    USA
    MS-Off Ver
    Excel Mac 2011
    Posts
    6

    using INDEX and IF to output value meeting multiple min/max range constraints

    Hello Excel Forum!

    I am attempting to output a value based on 4 different min/max range constraints. I have tried using INDEX with a nested IF but have been unable to determine a solution. Please see attached spreadsheet for a more detailed description on the problem.

    Thanks,
    Andrew
    Attached Files Attached Files
    Last edited by myersac; 04-30-2013 at 04:14 PM.

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