Forum Discussion

jlynnferrara's avatar
jlynnferrara
Copper Contributor
Aug 11, 2018

Excel CRE formula

Hi - I need to show yearly rental increases, but I only want to reflect the actual increase amount (pass through) and not the full amount. Ex. Year 1 is $2.00 w 3% increases each year after that. So each year has to show the increase off the previous year. Ex. If year two is $2.05, the I only want to shoe the .5, but year three would need to reflect a formula that shows the next 3% I’m increase off the $2.05 but only the .05 will be reflected in the cell.

1 Reply

  • Philip West's avatar
    Philip West
    Iron Contributor

    can you add a separate column to display the increase?

     

     AB
    1 TotalIncrease
    2  2.05=VALUE(RIGHT(A2,3))
     3  

     

    This would show 0.05 in B2

Resources