I would like to calculate a .5% reduction of a number over a 10 year period with the .5% reduction calculated on the previous reduction. Example 100 - .5% = 99.5, then 99.5 - .5% = 99.0025, then 99.0025 - 5% = 98.52988. I tried a simple =c45-.5% but that doesn't work. I know it's probably...