+ Reply to Thread
Results 1 to 3 of 3

Rounding with exponent

  1. #1
    Registered User
    Join Date
    10-17-2019
    Location
    Charleston, SC
    MS-Off Ver
    2016
    Posts
    1

    Rounding with exponent

    Hi everyone, this is my first post here. I consider myself an intermediate skill-level with Excel, and I use it at work quite a bit, but right now I'm stumped.

    In the simplest form, I'm trying to figure out a formula that will multiply a cell by a another cell which is a percentage, then round that number to the nearest 1/100th (2 decimal places), then multiply that rounded number by the same percentage, round that result, and continue multiplying it X number of times.

    I've tried using ROUND function, and POWER and ^ for applying exponents, but the resulting number I'm getting is that it rounds the number after the full calculation is complete. Is there any way to get it to round in between iterations of the multiplier? I know could create a table for this calculation, and then VLOOKUP or INDEX/MATCH to the resulting cell that I'm after, but I'd rather be able to have the full calculation occur within that cell.

    Here's what my best try was...
    =ROUND(T10*(1+R10)^(YEAR($D$4)-S10),2)

    The idea is a tenant's pro-rata share of an expense is capped at a growth rate of X% per year. T10 is the cell containing the original pro-rata share, R10 is the cell containing the growth percentage, D4 is the cell containing the year of the pro-rata share cap being calculated, and S10 is the cell containing the base year for the original pro-rata share.

    For purposes of trying this, here's the values I'm working with on this particular tenant...

    Base Year of Cap: 2015
    Year of Calculation: 2019
    Base Pro-Rata Share: $2.79
    % Growth per Anum: 4%

    Using this data, the value being returned with the formula above is $3.26. However, if you do the math manually, rounding for each year, then you come out to $3.27.

    How can I get the formula to round like that so that it returns a value of $3.27?

  2. #2
    Forum Expert
    Join Date
    05-01-2014
    Location
    California, US
    MS-Off Ver
    Excel 2010
    Posts
    1,795

    Re: Rounding with exponent

    See my response to the same question at https://www.mrexcel.com/forum/excel-...-exponent.html .

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,879

    Re: Rounding with exponent

    Administrative Note:

    Welcome to the forum.

    We would very much like to help you with your query, however it has been brought to our attention that the same query has been posted on one or more other forums and you have not provided the required cross-post link(s) here.

    Please see Forum Rule #3 about cross-posting and adjust accordingly. Read this to understand why we (and other sites like us) consider this to be important.

    (Note: this requirement is not optional. No help to be offered until the link is provided.)
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. [SOLVED] Vba exponent calculator
    By Leo313 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-02-2017, 05:10 PM
  2. Increasing the exponent by one per cell
    By P2502 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-23-2014, 01:30 PM
  3. finding a exponent with EXCEL
    By navalweaponsofficer in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 02-27-2014, 06:33 AM
  4. Keeping the exponent at a fix value in Excel
    By WAYNEL in forum Excel General
    Replies: 1
    Last Post: 01-09-2006, 11:45 AM
  5. [SOLVED] Keeping the exponent at a fix value in Excel
    By WAYNEL in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-09-2006, 11:45 AM
  6. Keeping the exponent at a fix value in Excel
    By WayneL in forum Excel General
    Replies: 6
    Last Post: 01-09-2006, 04:30 AM
  7. Turning off the Exponent Function
    By Jeffn21 in forum Excel General
    Replies: 0
    Last Post: 01-10-2005, 12:04 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