Results 1 to 8 of 8

Formula Help - If value falls within range (two columns) then return third value

Threaded View

  1. #1
    Registered User
    Join Date
    11-07-2022
    Location
    Atlanta
    MS-Off Ver
    Not sure
    Posts
    3

    Formula Help - If value falls within range (two columns) then return third value

    Hello! I'm looking for help with a formula.

    I've included a screenshot. I have an initial value (in the screenshot, it's 103%). Now, I want to find where in the Min and Max columns that number falls between. If it falls between a range of numbers, it should return the corresponding value in column "payout %"

    For this example, the value returned should be 120%.

    Screen Shot 2022-11-07 at 1.59.52 PM.png

    Thanks so much!
    Attached Files Attached Files
    Last edited by laurend7; 11-07-2022 at 03:47 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Return Value if date falls within range
    By Kcroft9 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 03-01-2019, 07:43 AM
  2. [SOLVED] Formula to return YES if the value falls within a range.
    By bacowarrior in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 01-19-2016, 03:04 PM
  3. [SOLVED] Return MIN and MAX within a range of data that falls within a specified MIN and MAX.
    By dcourtney in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-05-2014, 06:26 PM
  4. Replies: 15
    Last Post: 04-08-2013, 12:40 PM
  5. How to return a value that falls within a range
    By friend11_6 in forum Excel General
    Replies: 5
    Last Post: 03-18-2011, 01:06 AM
  6. [SOLVED] Return a value that falls within a defined range
    By Suzieq in forum Excel General
    Replies: 2
    Last Post: 07-25-2006, 02:45 PM
  7. Return a specified date when it falls within a range....
    By Nokose451 in forum Excel General
    Replies: 1
    Last Post: 01-16-2006, 06:10 PM

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