+ Reply to Thread
Results 1 to 2 of 2

Return value of interval number

  1. #1
    Registered User
    Join Date
    01-13-2014
    Location
    Portugal
    MS-Off Ver
    Excel 2013
    Posts
    1

    Return value of interval number

    Hello,
    I want to make a formula that returns a value of a interval, this value is estimated from a serial of 10 intervals with up and down value.

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    14,323

    Re: Return value of interval number

    I'm not sure I understand exactly what you want, but I expect one of Excel's lookup (like the vlookup() function http://office.microsoft.com/en-us/ex...011.aspx?CTT=1) functions should be able to do what you want. Perhaps =vlookup(D19,$D$6:$F$15,3,true)
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. How to Mark a Cell with a specified Number of interval
    By kretos88 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2013, 04:43 PM
  2. Replies: 2
    Last Post: 06-25-2012, 03:49 PM
  3. [SOLVED] count the number of events in an interval
    By invictus in forum Excel General
    Replies: 4
    Last Post: 06-11-2012, 06:17 PM
  4. How to count number of people per time interval
    By chinkygirl in forum Excel General
    Replies: 1
    Last Post: 02-11-2012, 01:33 PM
  5. [SOLVED] Calculate a number based on an interval
    By Vitalie Ciobanu in forum Excel General
    Replies: 4
    Last Post: 03-19-2006, 04:00 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