+ Reply to Thread
Results 1 to 3 of 3

RRI Function Help

  1. #1
    Registered User
    Join Date
    02-28-2023
    Location
    US
    MS-Off Ver
    2016
    Posts
    2

    RRI Function Help

    What would I put into the formula bar to get the hardcoded RRI column on the far right?
    Attached Images Attached Images

  2. #2
    Valued Forum Contributor
    Join Date
    07-13-2021
    Location
    California, USA
    MS-Off Ver
    2010
    Posts
    513

    Re: RRI Function Help

    In the future, please follow the instructions at the top of this webpage to attach an example file, or at least post the data in a form that is easy to copy-and-paste into Excel.

    For the example below:

    rri example.jpg

    the formula in O3 is:

    =RRI(COUNTIF(B3:M3,">0")-1, B3, IFERROR(INDEX(B3:M3, MATCH(0, B3:M3, 0)-1), M3))

    That assumes that any zeros are always at the end of the series.

    In effect, O3 is =RRI(COLUMNS(C3:M3), B3, M3), which is equivalent to
    =RATE(COLUMNS(C3:M3), 0, -B3, M3) or =(M3/B3)^(1/(COLUMNS(C3:M3)) - 1.

    O4 is =RRI(COLUMNS(C3:G3), B3, G3).

    PS.... The formula can be simplified if you leave cells empty instead of entering zeros.

    PPS.... Minor simplifications. If they are confusing, stick with the original formula.

    =RRI(COUNTIF(C3:M3,">0"), B3, IFERROR(INDEX(C3:M3, MATCH(0, D3:M3, 0)), M3))

    -----
    Attached Files Attached Files
    Last edited by curiouscat408; 03-01-2023 at 05:36 PM.

  3. #3
    Registered User
    Join Date
    02-28-2023
    Location
    US
    MS-Off Ver
    2016
    Posts
    2

    Re: RRI Function Help

    Thank you so much. I will keep that in mind for next time I post!

+ 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. Replies: 1
    Last Post: 02-10-2023, 10:18 AM
  2. [SOLVED] Left function, Right Function, or Mid Function to extract values to three decimal places
    By bjnockle in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 01-08-2023, 03:22 AM
  3. Right function, Left function, Mid function to extract values in column A
    By bjnockle in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 06-14-2020, 03:14 PM
  4. COUNTUNIQUE Function in Google Sheets; Excel lacks a direct counterpart to this function?
    By PivotTablePSHomage in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2018, 05:27 AM
  5. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  6. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  7. Replies: 1
    Last Post: 03-21-2012, 11:22 AM

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