Forum Discussion
jlynnferrara
Aug 11, 2018Copper Contributor
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 WestIron Contributor
can you add a separate column to display the increase?
A B 1 Total Increase 2 2.05 =VALUE(RIGHT(A2,3)) 3 This would show 0.05 in B2