Forum Discussion
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 e...
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