Hi, I would like to add a formula to deliver a result into a cell.
I have a cell with a date going back years. I want to calculate back from today to that date and if 3 or 5 or 7 years difference, multiply another currency cell by a percentage to give a currency value.
Example Cell B2 is April 2103 and cell B3 is £45. I want cell B4 to work out the time difference from today and if B2 is 3 years old multiply B3 by 10%, if B2 is 5 years old multiply B3 by 15% and if B2 is 7 years old multiply B3 by 20% and the result each time should be shown in B4.
Solved by S. Y. in 30 mins