Results 1 to 7 of 7

Display value 1 row down from closest round number > static value

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-02-2007
    Location
    Australia NSW
    MS-Off Ver
    2013
    Posts
    494

    Display value 1 row down from closest round number > static value

    I have attached a sample of what formula i am after.
    Basically i have a row of values, that i need compared to an entered value.
    The result required is to find from the row of data, the next > value to the entered value, and return the cell value in row 3(offset1 row).

    Hope i have explained that ledgebly enough to comprehend.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 13
    Last Post: 08-13-2013, 12:51 PM
  2. [SOLVED] display number of days if less than 7 otherwise round up to months
    By chrisio in forum Excel General
    Replies: 3
    Last Post: 09-20-2012, 08:35 AM
  3. How to round up to closest match in vlookup
    By Onestopfanshop in forum Excel General
    Replies: 1
    Last Post: 01-04-2011, 02:41 PM
  4. [SOLVED] How can i round a number to closest tenth number?
    By rayne95 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-19-2006, 04:40 PM
  5. Replies: 4
    Last Post: 01-27-2005, 05:06 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