Results 1 to 3 of 3

Nested IF (index and match)

Threaded View

mikera Nested IF (index and match) 01-21-2010, 11:18 AM
DonkeyOte Re: Nested IF (index and... 01-21-2010, 11:26 AM
mikera Re: Nested IF (index and... 01-21-2010, 11:27 AM
  1. #1
    Registered User
    Join Date
    01-29-2009
    Location
    Houston
    MS-Off Ver
    Excel 2003
    Posts
    43

    Nested IF (index and match)

    I'm trying to hone a quoting tool to generate an amount based on a given range and minimum charges for specified subsects of the range. If you reference the attachment I'm trying to calculate a charge in cell K15 based on values in B9 and C10 referencing the table I8:R9. What I cant figure out is how to create a minimum charge of 50 for J8:P9 (points A-G) and a charge of 95 for Q8:R9 (points H-I).

    Let me know if you have any questions, and thanks in advance.
    Attached Files Attached Files
    Last edited by mikera; 01-21-2010 at 11:27 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