Hi Everyone, I would like to enter a formula in column C that calculates a percentage of value based on the age of the entry.
A B C
1 Labour Date Labour Charge Revised Labour Charge
2 09/12/2013 58.59
3 20/05/2014 30.09
4 11/06/2014 60.18
Column C should contain the formula which calculates column B dependent on the age in column A, i.e. if Column A is >12 months, B2*0%, A is <=12 months and >9 months, B2*25%, A is <=9 months and >6 months, B2*50%, A is <=6 months and >3 months, B2*75%, A is <=3 months, B2*100%
Any help with this would be greatly appreciated.
Many thanks
Bookmarks